Connect to SQL Server using Management Studio using Windows credentials, not in a domain

Question

I have a client installing SQL Server 2008. They gave me a username / password for a Windows domain in their domain, however my workstation is not in their domain. I am trying to connect to Management Studio on Vista Professional.

I tried using "network accounts" under "user accounts" and this works for other resources (such as sharing, TFS and file servers), but I was out of luck with this approach for SQL Server.

Also, I'm not sure if this is a problem, but it is an instance of dev on its database server. Thus, the connection string is "Computer_Name \ Instance".

One more question: how can I get integrated security for asp.net through cassini / Visual Studio 2008.

So far, my only solution is to cave and use SQL Server login. I would like to know if I have any other options.

Answer 1

The answer to this question is here . Very useful in the situation you mention.

Basically, you need to use the / netonly / user: domain \ username switches when opening the management studio, for example:

runas /netonly /user:domain\username "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" 

Hope this helps.

Answer 2

The details are a bit unclear, but if your workstation is not in their domain, do you enter the username as "domainname \ username"?