SQL Server Performance

how to create Login to Log Shipping Server Databases

Discussion in 'SQL Server 2005 Log Shipping' started by rayala.thulasi, Jul 6, 2009.

  1. rayala.thulasi New Member

    Hi all,
    Here I am facing one issue in Log Shipping server:
    I have configured the Log Shipping in my production server and those databases are in Read-only/Standby mode for the purpose of Reporting Services. After configuring the Log shipping the login are not updated from Production server to Log shipping server have only login with sa account. For the security reason I am not interested share this sa account password to any developer. Could anyone suggest me to associate the log in with those database read-only databases? Is there any way to achieve this requirement?
    I want to give datareader permission to that account.
    Thanks in advance
  2. satya Moderator

    Are you not using FIXED DATABASE roles for those databases, if so whats the problem in using the developers on the secondary server. But bear in mind if you are creating any new logins on fly then you must recreated on secondary server too, as the log shipping only takes care on user databases and not for MASTER database.

Share This Page