SQL Server Performance

problem with users rights

Discussion in 'SQL Server 2005 Database Mirroring' started by peluche13000, Dec 5, 2006.

  1. peluche13000 New Member

    Hello,
    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.
    Cordially,
    Helene
  2. satya Moderator

    This is due to orphaned users on the user database, refer to relevant KBAs:
    http://support.microsoft.com/kb/274188/
    http://support.microsoft.com/kb/246133/
    http://support.microsoft.com/kb/168001/

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. peluche13000 New Member

    Thank you for your help.
    It was the problem. Now it's solved.

Share This Page