Hi All, I get the following error while building the cube.It says Failed to connect to the Analysis Services server.A connection cannot be made. Ensure that the server is running. The queue status shows that the job is 50% complete and the job has failed but not blocking correlation. How should i resolve?? ===== Initiating cube build process ===== [12/11/2007 17:00] Cube build request message has been added to the Project Server queue ===== Verifying and running pre-build server event handler ===== [12/11/2007 17:00] Verifying and running pre-build server event handler ===== Determining database and cube structure ===== [12/11/2007 17:00] Cube build initialization started [12/11/2007 17:00] OLAP database and cube structure was determined successfully ===== Building database and cubes ===== [12/11/2007 17:00] Cube build session started [12/11/2007 17:00] Analysis Services session started [12/11/2007 17:01] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server PRJSRV. Error: A connection cannot be made. Ensure that the server is running. ===== Process Completed ===== [12/11/2007 17:01] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server PRJSRV. Error: A connection cannot be made. Ensure that the server is running. -- Thanks & Regards, Jaishree
Hi Jaishree , Try posting on the server newsgroup as this one is closing down. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address:http://project.mvps.org/faqs.htm . Mike Glen Project MVP Jaishree wrote: > Hi All, > > I get the following error while building the cube.It says Failed to > connect to the Analysis Services server.A connection cannot be made. > Ensure that the server is running. > The queue status shows that the job is 50% complete and the job has > failed but not blocking correlation. > > How should i resolve?? > > ===== Initiating cube build process ===== > [12/11/2007 17:00] Cube build request message has been added to the > Project Server queue > ===== Verifying and running pre-build server event handler ===== > [12/11/2007 17:00] Verifying and running pre-build server event > handler ===== Determining database and cube structure ===== > [12/11/2007 17:00] Cube build initialization started > [12/11/2007 17:00] OLAP database and cube structure was determined > successfully > ===== Building database and cubes ===== > [12/11/2007 17:00] Cube build session started > [12/11/2007 17:00] Analysis Services session started > [12/11/2007 17:01] Analysis Services session failed with the following > error: Failed to connect to the Analysis Services server PRJSRV. > Error: A connection cannot be made. Ensure that the server is running. > ===== Process Completed ===== > [12/11/2007 17:01] Failed to build the OLAP cubes. Error: Analysis > Services session failed with the following error: Failed to connect > to the Analysis Services server PRJSRV. Error: A connection cannot be > made. Ensure that the server is running.
