SQL Server Performance Forum – Threads Archive
problem with users rightsHello,
I currently have 2 servers Windows Server 2003 with SQL Server 2005.
I want to set up database mirroring environment. I have a base on the first server which I want restore on the second.
In this base, there are Windows users and a SQL Server user.
I make a backup of my first base. When I restore this base on the second server, the rights to access to the server are intact only for users NT, not for account SQL Server. The SQL Server user cannot access the base any more.
Thanks for help me to solve this problem.
This is due to orphaned users on the user database, refer to relevant KBAs:
http://support.microsoft.com/kb/168001/ Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thank you for your help.
It was the problem. Now it’s solved.