SQL Server Analysis Server question...

D

DerekM

I'm trying to setup PS 2007 to build the cube. I've installed SQL Server
Analysis server but when I try to build the cube I get the following error:
"Failed to Connect to the Analysis Server: A connection cannot be made"

I rebooted and tried again but no luck.

In the 'Cube building Setup' screen I enter the name for the Analysis Server
= MSSQLSERVER
And enter 'pwa' for the name of the databse to be created, Extranet and
Description i leave blank

When I look at the SQL Server Configuration Manager I see the Analysis
server running properly.

Any ideas were to look now?
Thanks.
 
L

lynne

I'm trying to setup PS 2007 to build the cube. I've installed SQL Server
Analysis server but when I try to build the cube I get the following error:
"Failed to Connect to the Analysis Server: A connection cannot be made"

I rebooted and tried again but no luck.

In the 'Cube building Setup' screen I enter the name for the Analysis Server
= MSSQLSERVER
And enter 'pwa' for the name of the databse to be created, Extranet and
Description i leave blank

When I look at the SQL Server Configuration Manager I see the Analysis
server running properly.

Any ideas were to look now?
Thanks.
Click to expand...

have you set up the comm+ component?
which version of SQL server are you using?
 
D

DerekM

Yes, Project Server and SQL Server on same machine.
SQL Server 2005 standard edition
What is comm+ component?
 
L

lynne

Derek,

Are both project server and SQL server on same machine?
--
Gaurav Wason
[email protected]
MCP - Project Server
Project Made Easy
Project Archive Tool
Project Owner Toolhttp://projectmadeeasy.com









- Show quoted text -
Click to expand...

Is it Com+ installed? What version of SQL server are you using?
 
Top