SSTS Blog

Some news and tidbits that we share

Creating new logins with SQL Server High Availability Groups

by SSTS
SSTS
Server Side Technology Solutions is a consulting firm that specializes in databa
User is currently offline
on Jan 10 in Blog 0 Comments

If you add new logins to your environment and want the associated database permissions to flow through to replicas you must create the logins with common sid identifiers. To do so query for the sid for the login from the syslogins table. After you have the sid you can create the login on the replicas as follows:

create login <name> with password='', sid=<sid>

After you do this database permissions will flow through from the primaries to the replicas and in the event of fail over users will have their appropriate access.

Tags: Untagged
Hits: 6673

About the author

SSTS

Server Side Technology Solutions is a consulting firm that specializes in database design, development and support.

Comments

Please login first in order for you to submit comments