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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Connect to Analysis Services from Client Management Studio?

Status
Not open for further replies.

JawKnee

Programmer
Apr 19, 2004
7
US
From my client machine, I have no trouble accessing the Database Engine of my 2005 server in SQL Server Management Studio since I can use SQL Server Authentication. However, Analysis Services (at least how my server is configured right now) only allows Windows Authentication and I cannot connect. For what it's worth, I can't connect to the Database Engine either on my client using Windows Authentication.

What do I need to do to connect to Analysis Services from my client Management Studio?
 
I figured it out.

I had to make an exception for port 2383 (or whatever the default port is for Analysis Services) in Windows Firewall on the Analysis Services server.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top