|
Home > Archive > MS SQL Server > March 2006 > How to connect the remote SQL 2005 using different user name?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to connect the remote SQL 2005 using different user name?
|
|
|
| Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesn’t allow to make any changes, does anyone have the idea how to make the
change?
Thanks
Wendy
| |
| Sue Hoegemeier 2006-03-14, 3:23 am |
| One thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@discussions.microsoft.com> wrote:
>Hi,
>
>I am using the SQL 2005 management studio and trying to connect a remote SQL
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up the
>user name and password which is using for local login and gray out, it
>doesn’t allow to make any changes, does anyone have the idea how to make the
>change?
>
>Thanks
>
>Wendy
| |
| Wendy 2006-03-14, 11:23 am |
| Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:
> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
>
> -Sue
>
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@discussions.microsoft.com> wrote:
>
>
>
|
|
|
|
|