I am experiencing issues when connecting to AS from SSMS. I get the following error:
Cannot connect to InstanceName
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
I have found out that this was a known issue in before SP1. However I am already on SP2. Not sure why am I getting this error. I am able to connect to AS on the server itself but not from some other machines. Remote connections for AS are enabled.
any ideas what might be going on here?
thanks
Hi,
can you give us more information on what is the name of the server that you are trying to connect to?
what are specifying in the connection parameters in ssms?
Regards
|||Have you read Edward Melomed's article on troubleshooting connectivity issues?
http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx
HTH,
Chris
No comments:
Post a Comment