Connect to SQL Server with Management Studio using a Windows Credential while not on the domain

Question

I have a client that has a SQL Server 2008 installation. They have given me a windows domain username/password on their domain, however, my workstation is not on their domain. I'm trying to connect with Management Studio on Vista Professional.

I've tried using the "network accounts" under "user accounts", and this works for other resources (such as exchange, TFS, and file servers) but I have had no luck with this approach for SQL Server.

Also, I'm unsure if this is a concern but this is a dev instance on their database server. So the connection string is "Computer_Name\Instance".

A further question: how could I get Integrated Security for asp.net through cassini/Visual Studio 2008.

So far my only solution is to cave and use a SQL Server Login. I'd like to know if I have any other options.

Answer 1

The detail is a bit unclear, but if your workstation is not on their domain then are you entering the username as 'domainname\username' ?

Answer 2

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

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

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

Hope that helps.