Connecting from Management studio with *another* windows account

I'm trying to connect to a SQL Server at work from my virtual PC> The
virtual PC is not logged in under my domain account as it is not part of
the domain.
I need to be able to connect to the domain account using Windows
Authentication. For other services (sourcesafe, printing, shares etc) I
can use "net use \\servername /user:domain\password " to connect under
another account. Sql Server Management studio however does not recognise
this and still tries to log in with vpc\administrator instead.
I'm unable to start the program using runas either (fails with unknown
user or bad password).
Is there a way to connect using a different account without resorting to
SQL accounts?
Jesse"Jesse Houwing" <jesse.houwing@.nospam-sogeti.nl> wrote in message
news:OBtjE$exGHA.1224@.TK2MSFTNGP03.phx.gbl...
> I'm trying to connect to a SQL Server at work from my virtual PC> The
> virtual PC is not logged in under my domain account as it is not part of
> the domain.
> I need to be able to connect to the domain account using Windows
> Authentication. For other services (sourcesafe, printing, shares etc) I
> can use "net use \\servername /user:domain\password " to connect under
> another account. Sql Server Management studio however does not recognise
> this and still tries to log in with vpc\administrator instead.
> I'm unable to start the program using runas either (fails with unknown
> user or bad password).
> Is there a way to connect using a different account without resorting to
> SQL accounts?
>
Without joining your VPC to the domain, you can create local accounts
accounts on both your VPC and your SQL Server (not its domain). The
accounts must have the same password, and appropriate group memberships on
each box. Then Windows will use "workgroup authentication" and your local
user MyVPC\Fred will be able to access resources on the SQL Server as
MySQLServer\Fred.
This is a different mechanism from "net use", and works for all kinds of
authenticated traffic.
David|||* David Browne wrote, On 22-8-2006 16:14:
> "Jesse Houwing" <jesse.houwing@.nospam-sogeti.nl> wrote in message
> news:OBtjE$exGHA.1224@.TK2MSFTNGP03.phx.gbl...
>> I'm trying to connect to a SQL Server at work from my virtual PC> The
>> virtual PC is not logged in under my domain account as it is not part of
>> the domain.
>> I need to be able to connect to the domain account using Windows
>> Authentication. For other services (sourcesafe, printing, shares etc) I
>> can use "net use \\servername /user:domain\password " to connect under
>> another account. Sql Server Management studio however does not recognise
>> this and still tries to log in with vpc\administrator instead.
>> I'm unable to start the program using runas either (fails with unknown
>> user or bad password).
>> Is there a way to connect using a different account without resorting to
>> SQL accounts?
>
> Without joining your VPC to the domain, you can create local accounts
> accounts on both your VPC and your SQL Server (not its domain). The
> accounts must have the same password, and appropriate group memberships on
> each box. Then Windows will use "workgroup authentication" and your local
> user MyVPC\Fred will be able to access resources on the SQL Server as
> MySQLServer\Fred.
> This is a different mechanism from "net use", and works for all kinds of
> authenticated traffic.
This is unfortunately no option :(
This would force the creation of many extra users for which passwords
need to be synchronised and such...
Jesse