Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: log shipping login sync

    Hi,

    I have log shipping setup working fine. I created new login (jskow) on primary server and he is a valid user in the database which is configure for log shipping, My secondary server is read-only. I want to give jskow read access on secondary, I added jskow to secondary server, log shipping copied that database user to secondary database , but when I try to login to secondary server and use the read-only database , I get error not a valid user?,

    any help?

    thanks in advance.

    Ram.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run SP_CHANGE_USERS_LOGIN with REPORT clause and see whether the login reported as orphaned user, if so use AUTO_FIX to fix the login.

    Refer to BOOKS ONLINE for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •