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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2007-01-30 : 13:57:42
|
| We have migrated to new windows domain.--I have old domain\user in db user1 with all relevant privleges--When I go to setup new domain\user1 it seems that through security/logins/db access when you click a db for access SQL drops the domain prefix and uses user1 at which point it complains that it already exists and cannot be used. problem is there are objectscreated by this owner (old domain) so I can't delete.any help would be appreciated.thanks John |
|
|
mnegron
Starting Member
1 Post |
Posted - 2007-01-30 : 14:58:16
|
| you can map the uid of the new domain on master..syslogins to the existing user id on the database.ieUSER MASTERSELECT SID, NAME FROM SYSLOGINSWHERE NAME LIKE 'new_domain%'USE DATABASEUPDATE SYSUSERS SET SID='result of query'where name = 'USER NAME' |
 |
|
|
|
|
|
Problem with DB user