Orphaned Users afret restor - SQL 2005

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Orphaned Users afret restor - SQL 2005

Author

Topic

anxcomp
Starting Member

41 Posts

Posted - 2007-08-19 : 10:32:47

Hi,

I've restored my database from backup on another SQL 2005 server and can't login, could you tell me what is the best way to repair this on SQL 2005, please

--
Regards,
anxcomp

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-19 : 17:04:59

You need create sql logins on target server and remap db users to them with sp_change_users_login.

anxcomp
Starting Member

41 Posts

Posted - 2007-08-20 : 15:52:19

Thanks rmiao, I've done this. I suggest reed this articles:

When you don't have login on destination server as user on source database
http://support.microsoft.com/kb/246133/

and this when you have the same login on destination server as user on source database
http://support.microsoft.com/kb/274188/
http://support.microsoft.com/kb/240872/

and general info:
http://support.microsoft.com/kb/314546

--
Regards,
anxcomp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources