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 |
|
nkpriya
Starting Member
34 Posts |
 Posted - 2012-01-03 : 13:11:00
|
| I have a scenario here. We have SQL server 2005 in the office maintained at corporate level. When I try to login to management studio using my windows network id using windows authentication, I am able to connect to it. Then we have windows service accts with unexpired passwords. I know that this acct has access to the sql server, how can I connect to sql server using this windows service acct. Where can I specify this windows id and password. This is not my network id. Please let me know any suggestions. Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-03 : 13:13:35
|
| you need to login using that account and then open management studio and connect to server if you need to connect to sql server using other network id which never expires------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
windows authentication - with different windows id