Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wendy
Starting Member
19 Posts |
 Posted - 2006-03-13 : 16:02:06
|
| 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?ThanksWendy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-13 : 16:06:22
|
| You can not do that using Windows Authentication. It passes the credentials of the person logged in. If that won't work for you, then you'll need to use SQL authentication.Tara Kizeraka tduggan |
 |
|
|
JeffK95z
Starting Member
19 Posts |
Posted - 2006-03-14 : 01:10:24
|
| I've done this by right-clicking on EM or QA and using the run-as option...You'll just have to create the remote user (same username/password) on your local machine.I've tested this on sql 2000, but not 2005. It should work as well.jeff |
|
|
|
wendy
Starting Member
19 Posts |
Posted - 2006-03-14 : 10:32:12
|
| Thanks for all 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 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-14 : 12:38:14
|
quote:
That means the windows authentication is very limited.
That is not the case. Your environment is limiting your options. Why do you need to use a different windows login? Is this due to two domains? If so, then why not just setup a trust relationship between the two?Tara Kizeraka tduggan |
|
|
|
|
|
|
Connect the remote SQL 2005 using different user?