SQL Server Performance Forum – Threads Archive
error connecting to AS from some machinesI 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
You must be aware with the fact that AS uses Windows credentials only, for connection.
So make sure that win login is getting verified. Also if possible for you, please move your thread to 2005 Analysis server section here.