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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-08-02 : 05:29:56
|
| Gurusi have restored one DB.that DB has got a windows login as a user.Now i have to restore this DB on new server.If i create a new login how will i put the old passowrd and how will i map the lofin and user if there is windows user.Please helpRegardsNitin |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-08-02 : 07:34:03
|
| If it's a windows login then the password is controlled by windows. The user should already exist when you restore the database and you should be able to connect it together with the login.-------Moo. :) |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-02 : 07:39:15
|
| HiI understand yes the user is already there,but what about the login.the login will be different on both the servers.for example on serverone thelogin was host938/loginnameand on server 2 the login will be host939/loginname.So that meanz i cant keep the login name same on both the servers?Plz helpregardsNitin |
|
|
|
|
|
|
Mapping windows login