Paul Liebrand's Weblog

Welcome to my blog mainly about SharePoint

Skip to: Content | Sidebar | Footer

Google Search

Project Server 2007 and SQL Server 2008 Analysis Services Issues

3 March, 2010 (09:42) | Project Server 2007, SharePoint | By: Liebrand

I ran into an issue attempting to get Project Sever 2007 working with SQL Sever 2008 Analysis Services and thought I would create a post about it in case other people are experiencing the same issue.

The first thing to note is the article on TechNet are written as if everything is installed on the same server; that is not the case in my environment. High level overview of my environment:

  • SharePoint Farm
  • Distributed SQL Server 2005 (stores SharePoint DBs and Project Server 2007 DBs)
  • Distributed SQL Server 2008 Analysis Services (for Project Server 2007 cube)

The second thing to note is that the instructions for using SQL Server 2008 Analysis Services specifically call out installing the following components from the Feature Pack for Microsoft SQL 2005 – December 2008 (in this order):

  • SQL Native Client
  • Microsoft SQL Server 2005 Management Objects Collection
  • Microsoft SQL Server 2005 Backward Compatibility Components

Following these instructions to a tee I received the following error message when attempt to build my cube:

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <<SAS Server>>. Error: Cannot connect to the repository. Analysis server: <<SAS Server>> Error: Provider cannot be found. It may not be properly installed.

According to the troubleshooting guide at the bottom of the article this means I do not have the right version of the client installed. Very baffling – I installed everything straight from the links provided in the article.

Next I decided to create the cube against a SQL Server 2005 Analysis Service to see if I had any different results.

Upon creating the cube, I received the following error message:

Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <<SAS Server>>. Error: Cannot connect to the repository. Analysis server: <<SAS Server>> Error: SQL Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF].

I did a little searching with the help of a co-worker and I was able to resolve both these issues.

Solutions

1. Error: Provider cannot be found. It may not be properly installed.

This issue was resolved by installing the SQL 2008 Native Client on the Project Server 2007 server. Yes, the SQL 2005 Native Client, 2005 Management Objects Collection, and 2005 Backwards Compatibility Components are still needed.

2. SQL Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF]

This issue was resolved by making the following registry change on the Project Server 2007 server.

Locate the following registry key:

HKLM\Software\Microsoft\MSSQLServer\Client\SNI9.0

And for the ProtocolOrder entry should be set to:

tcp
np
sm

Reference: http://serverfault.com/questions/53915/sql-server-2005-error-getting-enabled-protocols-list-from-registry-xffffffff

I hope this helps anyone else that struggled with this.


Post to Twitter Post to Delicious Post to Digg Post to Facebook Post to Reddit

  • Diego

    Great post! I had the same problem, I checked documentation and tested everything several times with no luck. Now it works fine.
    Thanks.

  • Cf

    Thanks a lot! This fixed my mysterious magical problem.