replicate between 2 sql login database

Question

replicate between 2 sql login database

Kevin Tan-413223

SSC Enthusiast

Points: 166
More actions
August 29, 2007 at 1:13 pm

#176363

I had 2 SQL2K5 on different site, can I repl/sync all SQL Login between this 2 box?

Thanks in Advance.

Viewing 9 posts - 1 through 8 (of 8 total)

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

noeld SSC Guru Points: 96590 More actions · Answer 1

SQL Logins are not "replicable" at least in the standard replication meaning. You can script them out and apply them as you often as you need them though.

* Noel

Kevin Tan-413223 SSC Enthusiast Points: 166 More actions · Answer 2

any idea how can I get the relavant script for this?

thx

Cath Trimble SSCarpal Tunnel Points: 4201 More actions · Answer 3

Hi Kevin,

In Management Studio browse to Security\Logins. Right click over the login you want to script and select Script Login As.. Create to...

Cath

Kevin Tan-413223 SSC Enthusiast Points: 166 More actions · Answer 4

Kevin Tan-413223

SSC Enthusiast

Points: 166

August 30, 2007 at 9:24 am

#730469

thx cath, will try it..cheers

JeremyE SSCoach Points: 16199 More actions · Answer 5

This article also explains how to transfer the SID's along with the logins using a couple of stored procs.

http://support.microsoft.com/kb/918992

Kevin Tan-413223 SSC Enthusiast Points: 166 More actions · Answer 6

this is brilliant, with this help me alot..thanks man...

noeld SSC Guru Points: 96590 More actions · Answer 7

noeld

SSC Guru

Points: 96590

September 4, 2007 at 5:02 pm

#731365

Otherwise the script works like a champ

* Noel

noeld SSC Guru Points: 96590 More actions · Answer 8

there is just on catch with that script. If sql server logins are generated and you use CHECK_POLICY you will have to modify it a bit

* Noel