Failed to build OLAP cube

A

amara sharif

Hi all,

I am trying build my OLAP cubes (i have SQL server analysis 2005) and i have this error message when i try to build my cubes:

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server LONINENGMSPROJ1. Error: Cannot connect to the repository. Analysis server: LONINENGMSPROJ1 Error: Named Pipes Provider: Could not open a connection to SQL Server [2].



I dont understand why it cannot connect to the server, i can connect to it via SQL manager.

In relation to the pipes, i have enabled TCP/IP and Pipes.

Any help is appreciated.
 
B

Ben Howard

Is your project server installed on the same server as your SQL server? Have
you created an AS Repository as per the installation instructions? Has it
ever worked?
 
Top