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 |
|
angler
Starting Member
1 Post |
 Posted - 2005-04-21 : 11:36:04
|
| I recently had to recover a database for a group.There were no recent backups of the master, model, msdb.After creating a SQL server and reattaching the additional databases. There were several orphaned logins. After running sp_change_users_login 'report' against some the databases I reassociated all but one a dbo login on on of the databases.When my users try and use this database they are asked to supply thesa password. I received a single suggestion to run sp_changedbowner 'sa' for this login. I am new to forum and thank you in advance for your assistance.Thank youAngler |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-21 : 12:51:04
|
| Look up orphaned users in BOL. Also, read the article posted below:http://support.microsoft.com/kb/274188/It is most likely a problem mapping the SID to the SA account. |
 |
|
|
|
|
|
Sa login required after SQL 7 Server restore