February 26, 2016 at 1:56 am
Hi i have configured logshipping in my primary server and secondary server .
everything works find untill i bring the standby database to online.
users are not able to login to the secondary server database ( which is in secondary server ,which we brings to online)
can any one help me on this.
February 26, 2016 at 2:24 am
LogShipping does not replicate server level objects such as logins, so your user will be unable to log in to the secondary server when you switch roles.
You can migrate existing logins using the sp_help_revlogin stored procedure, keeping SIDs and passwords for SQL authenticated logins.
-- Gianluca Sartori
February 26, 2016 at 9:48 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply