Project server can't connect to the repository database

[JBVA]

Here is the message I get when trying to build cube:

Failed to build the OLAP cubes. Error: Analysis Services session failed
with the following error: Failed to connect to the Analysis Services server
xxxxx.xxx.xxx.xxx. 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).

Here's what my tech guys says:

Well, it looks like it's connecting successfully to the Analysis Services
instance on xxxxx (you can tell from the message before the below error when
you're building the cube). Then once it's connected, it tries to connect to
the repository database, which is the database within the actual database
instance on xxxxx, and that's where it's dying. The error below says it
can't connect to the repository database. But when I follow the steps from
the msdn page, it has me set up that connection and it worked fine setting up
the connection (and it sees the repository database).

Any help would be greatly appreciated!
(e-mail address removed)

 

[Ben Howard]

Hi JBVA,

Presumably PS2007? This is a pretty common error, and basically says that
PS isn't set up correctly to talk to AS. Check out the deployment guides on
technet (not MSDN) and make sure the connections to the repositories are set
correctly within AS. There are lots of permissions to check too (eg check
the account that runs the SSP)

 

[Sarfaraz]

With the error listed, you need to configure the connection parameters
in the properties tab of the analysis server. You need to configure 2
parameters, remoterepositoryconnectionstring and
repositoryconnectionstring parameters under the DSO objects, in the
properties page of the analysis server.

Sarfaraz
www.LearnMsProjectServer.com
A dedicated video on setting up your analysis server is available
here.

 

[Skin357]

This Helped...

http://technet.microsoft.com/en-us/library/cc197263.aspx