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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top