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

Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows 2000

Microsoft has kindly posted articles on how to configure 2005 SSAS for
HTTP (formerly called XMLA) for Windows XP and Windows 2003 here:
http://www.microsoft.com/technet/pro.../httpasws.mspx
http://www.microsoft.com/technet/pro.../httpssas.mspx
However, I have not been able to find documentation to support or
refute support of this feature on Windows 2000. Is it possible to use
the native XMLA/SOAP support of SQL2005 when hosted on a Windows 2000
server?
Thanks!
Sorry, but I think you have to have XP or 2003. the native HTTP/SOAP support
in SQL Server does not work on 2000. I am not sure if SSAS for HTTP does
though. You need to check in an AS specific newsgroup.
Best regards
Michael
<russel.krause@.upsidesoft.com> wrote in message
news:1143500586.771866.101310@.j33g2000cwa.googlegr oups.com...
> Microsoft has kindly posted articles on how to configure 2005 SSAS for
> HTTP (formerly called XMLA) for Windows XP and Windows 2003 here:
> http://www.microsoft.com/technet/pro.../httpasws.mspx
> http://www.microsoft.com/technet/pro.../httpssas.mspx
> However, I have not been able to find documentation to support or
> refute support of this feature on Windows 2000. Is it possible to use
> the native XMLA/SOAP support of SQL2005 when hosted on a Windows 2000
> server?
> Thanks!
>