Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection problem with Analysis Services

Status
Not open for further replies.

bebbo1986

Programmer
Feb 12, 2008
43
DE
Hallo together,
I'm using a separat PC in the network as a kind of test server and installed SQL Server 2005 on it. And there I established a cube with SQL Server Analysis Services.
From my PC and with my account I have rights to read and write on this PC and with \\c161FI005\c$ I can open the C hard drive on it for example.
Now I want to use the addin Excel 2002/2003 Add-In für SQL Server Analysis Services SP1 and connect to the server with it.

But there always appears this error:
OLAP Server error on connection \\C161FI005
OLAP Server error: Unable to connect to the Analysis server. The server name \\C161FI005 was not found. Please verify that the name you entered is correct, and then try again.

But the name is right and it should work. What can I do?
Thanks for any help,
Martin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top