Sunday, 11 March 2012

Connect into SSAS from SSMS with diferent user

Hi,

I'm a consultant and I need to connect to differents SSAS Servers using Management Studio.

In each customer I have one different user. I use this user to connect into their network and access servers, drives and SQL Server (using SQL autenticate) from my laptop (without connect into domain from my user).

In some customers, when I've a drive mapped to server I can access SSAS, but I don't know why this happen only in some customers and how do this again.

I'd like if someone can help me.

Thanks.

You can specify User Name and Password connection string properties when connecting to AS, (but it is possible that Management Studio doesn't have UI for them). Mapping drive works sometimes because of how NETBIOS interacts with SSPI, but in general it is not reliable way of piggibacking of establishing credentials.|||

The runas command should do what you want:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1365877&SiteID=17

No comments:

Post a Comment