Post reply

Logins with Log Shipping Server

  • July 7, 2009 at 5:41 am

    #136075

    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

    Thulasi

  • July 7, 2009 at 5:53 am

    #1020972

    Slightly confused, so you may need to clarify. If the users exist in the database on the primary server then they will exist in the database on the secondary. Its impossible not to as you will have restored your database over to the secondary to setup log shipping. As its readonly, they would need datareader in the primary server to have this on the secondary.

    Also, if its a production system why would you give developers access to it anyway. The fact that its a read only version for reporting doesn't make it a dev environment to pay around against to my view. Don't they have dedicated dev environments?

  • July 7, 2009 at 6:02 am

    #1020978

    Create a user in the primary database with readonly permissions.Once it is shipped to secondary database create a login on secondary server with the SID of the user.Refer BOL how to create a login with SID.Then your login and user gets mapped on the secondary server.

    This is one way.

  • July 7, 2009 at 6:24 am

    #1020998

    hi ,

    thanks for your valuable suggestions:

    Before initiating the log shipping from primary to secondary server i have created the login in Primary server and i mapped associated databases in User Mapping Section.but after completion my log shipping activity that login is not appearing in the Security tab.but the user are in the respective databases.if the login not there under login means we can't able to connect know..

    in this situation how can i get the login for those databases.

    Thanks,

    Thulasi.

  • July 7, 2009 at 6:36 am

    #1021002

    For this case only i have given the solution above.

    Users are for databases and logins are for instance.With log-shipping you shipped a database and so users will be shipped.But logins wont be shipped with log-shipping.

  • July 7, 2009 at 7:12 am

    #1021038

    Thanks alot for your inputs.. by using that login i can able to achive to deploy the report in reporting server.

    i am trying to create a new log for instance..here i can able to create the login but i cannot map that databases in user mapping section because those db's are read only. so if i want to use use those databases in instance level means again i need to give sysadmin role..

    Thanks,

    Thulasi.

  • September 23, 2013 at 5:26 pm

    #1652517

    hi is this possible with sql login as well? or is it only possible with windows logins?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply