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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Re-attached DB lost users

Author  Topic 

silas2
Yak Posting Veteran

65 Posts

Posted - 2005-08-10 : 14:28:26
If you re-attach a db to a different server, presumably you are shutting out your users (by them not having logins to the new server). If you are moving to a different domain I can only think that having the sa pwd and switching to "Mixed Authentication" would be the only way to get back in to start adding new logins/users, is that correct?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-08-10 : 14:31:24
You can get in if you are a local admin on the database server and BUILTIN\Administrators group has not been removed from the sysadmin fixed server role.

To add your users programmatically:
http://www.windowsitpro.com/SQLServer/Article/ArticleID/16090/16090.html

Tara
Go to Top of Page

silas2
Yak Posting Veteran

65 Posts

Posted - 2005-08-10 : 14:36:05
That's a good point.
Go to Top of Page
   

- Advertisement -