SQL Server Analysis Server question...

[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.

 

[Gaurav Wason]

Derek,

Are both project server and SQL server on same machine?
--
Gaurav Wason
(e-mail address removed)
MCP - Project Server
Project Made Easy
Project Archive Tool
Project Owner Tool
http://projectmadeeasy.com

 

[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.

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

 

[DerekM]

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

 

[lynne]

Derek,

Are both project server and SQL server on same machine?
--
Gaurav Wason
(e-mail address removed)
MCP - Project Server
Project Made Easy
Project Archive Tool
Project Owner Toolhttp://projectmadeeasy.com









- Show quoted text -

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

 

[Diaa Hussein PMP - I would be glad to help]

Hi Derek
Please review this article it might help

http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx

 

[Gary L. Chefetz [MVP]]

Derek:

If you're doing this from your client machine, there are two requisites that
you must install on every machine that you want to connect to the cube data
in 2005:

MSXML 6.0
ASOLEDB Component

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com