Project Server 2007 and SQL Server 2005

C

Chris Hughes(UK)

Hi

I have downloaded the final version of Project Server 2007 from Microsoft
Licensing and have completed the install with no problems
As stated in the Readme file I have installed SP1 for SQL Server.

Everytime I try and build a cube I get the following error

===== Process Completed =====
[11/27/2006 7:23 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to the
Analysis Services server sbanb-sqldeve1. Error: The connection string to
repository needs to be specified in the 9.0 server properties (see
<DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

Has anyone got any ideas as to what is going on here??

Thanks

Chris Hughes
 
P

Paul Conroy

On the machine(s) with Project Server VWNotify service:

From
http://www.microsoft.com/downloads/...aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en download and install (in order):

..NET Framework 2.0 (if not already installed)
Microsoft Core XML Services (MSXML) 6.0
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Backward Compatibility Components (And select DSO
- no need to select the rest)
 
C

Chris Hughes(UK)

Hi Paul

As far as I am aware there is no VWNotify service in Project server 2007

Regards,

Chris Hughes

Paul Conroy said:
On the machine(s) with Project Server VWNotify service:

From
http://www.microsoft.com/downloads/...aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en download and install (in order):

.NET Framework 2.0 (if not already installed)
Microsoft Core XML Services (MSXML) 6.0
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Backward Compatibility Components (And select DSO
- no need to select the rest)



Chris Hughes(UK) said:
Hi

I have downloaded the final version of Project Server 2007 from Microsoft
Licensing and have completed the install with no problems
As stated in the Readme file I have installed SP1 for SQL Server.

Everytime I try and build a cube I get the following error

===== Process Completed =====
[11/27/2006 7:23 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to the
Analysis Services server sbanb-sqldeve1. Error: The connection string to
repository needs to be specified in the 9.0 server properties (see
<DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

Has anyone got any ideas as to what is going on here??

Thanks

Chris Hughes
Click to expand...
Click to expand...
 
P

Paul Conroy

Chris, you're quite right. These SQL components should be installed on the
Project Server Application Server (if you have split out your front end
servers).

Paul

Chris Hughes(UK) said:
Hi Paul

As far as I am aware there is no VWNotify service in Project server 2007

Regards,

Chris Hughes

Paul Conroy said:
On the machine(s) with Project Server VWNotify service:

From
http://www.microsoft.com/downloads/...aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en download and install (in order):

.NET Framework 2.0 (if not already installed)
Microsoft Core XML Services (MSXML) 6.0
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Backward Compatibility Components (And select DSO
- no need to select the rest)



Chris Hughes(UK) said:
Hi

I have downloaded the final version of Project Server 2007 from Microsoft
Licensing and have completed the install with no problems
As stated in the Readme file I have installed SP1 for SQL Server.

Everytime I try and build a cube I get the following error

===== Process Completed =====
[11/27/2006 7:23 PM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to connect to the
Analysis Services server sbanb-sqldeve1. Error: The connection string to
repository needs to be specified in the 9.0 server properties (see
<DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

Has anyone got any ideas as to what is going on here??

Thanks

Chris Hughes
Click to expand...
Click to expand...
Click to expand...
 
Top