Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 927159 - Last Review: September 18, 2011 - Revision: 3.0
Error message when you try to create a data analysis view in Project Server 2007: "Failed to connect to Analysis Service server"
When you try to create a data analysis view in Microsoft Office Project Server 2007, you receive the following error message:
Failed to connect to Analysis Service server. Verify the server name and try again.
This issue occurs if the following conditions are true:
- Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is not installed on the computer that is running Microsoft Project Web Access.
- The Analysis Services version is version 2005.
This issue may also occur if the
Access data sources across domains security setting in Microsoft Internet Explorer is set to
Disable.
To resolve this issue, you must install Analysis Services 9.0 OLE DB Provider or a later version of the OLE DB provider. Analysis Services 9.0 OLE DB Provider is included in the Feature Pack for Microsoft SQL Server 2005.
To download the Feature Pack for Microsoft SQL Server 2005, visit the following Microsoft Web site:
Make sure that you select the package that applies to the operating system that you are running, as follows:
- For x86-based computers, select X86 Package (SQLServer2005_ASOLEDB9.msi).
- For x64 Edition-based computers, select
X64 Package (SQLServer2005_ASOLEDB9_x64.msi).
- For Itanium-based computers, select IA64 Package (SQLServer2005_ASOLEDB9_ia64.msi).
If the
Access data sources across domains security setting in Internet Explorer is set to
Disable, you must set this setting to
Enable for the given security zone that you use to connect to Project Web Access. To do this, follow these steps:
- In Internet Explorer, click Tools, and then click Internet Options.
- Click the Security tab, click the zone that you use to connect to the Office Project Server 2007, and then click Custom Level.
- Under Access data sources across domains, select Enable.
Note If you set the security setting to Prompt, you cannot use the Office Web Components when you create a data analysis view.
Steps to reproduce the problem
- In Project Server 2007, create a new view under Manage Views on the Server Settings page.
- On the New View page, select Data Analysis next to View type.
- Under Analysis Services Settings, select Click to refresh database list.
You receive the error message that is mentioned in the "Symptoms" section.
APPLIES TO
- Microsoft Office Project Server 2007
| kbtshoot kbexpertiseinter kbprb KB927159 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate