Login synchornization from 1' to 2' with same SIDS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Author

Topic

Dinesh
Starting Member

10 Posts

Posted - 2004-09-29 : 13:51:21

Friends, I also ended up with similar requirement, In my case I need to do login syschronization between Primary server and Secondary Server.

It seems DTS - Transfer Logins Task will not transfer SIDs,

I need to Synchronize logins with same SIDS which are in Primary server. This process should be automatic., whenever a login ID was created in Primary, It should be automatically created in secondary

I too need this as an urgent.,

Could you people please jump in and share your thoughts

Thanks in advance

Dinesh

Dinesh

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-09-29 : 14:01:41

Search for sp_help_revlogin on this forum. The version on here will synch up the logins. For your "transfer process", you just need to run this, capture the results, and run it.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Dinesh
Starting Member

10 Posts

Posted - 2004-10-03 : 08:59:22

I'm trying to extract the logins which are present in Primary server / not present in secondary server with following query

Select name from <Linkdedservername>.master.dbo.Sysxlogins where name not in
(select name from sysxlogings)

the above query return nothing, whereas

Select name from <Linkdedservername>.master.dbo.Sysxlogins where name not in
(select name from syslogins) returns login ID not present in Secondary.,

What will be possible cause of this..,

I'm little confused, because syslogins is a view of sysxlogins table.,

Querying the view gives result, whereas querying base table of the view returns nothing..

Help please, Its an Urgent

Thanks in advance

Dinesh

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-04 : 13:41:28

So why aren't you using sp_help_revlogin which has been suggested twice now?

Tara

Dinesh
Starting Member

10 Posts

Posted - 2004-10-04 : 15:05:03

quote:
Originally posted by tduggan

So why aren't you using sp_help_revlogin which has been suggested twice now?

Tara

I'm using SP_HELP_REVLOGIN only,

But i'm trying to customize, so that this Procedure will only return
script for loginID which are present in Primary server but not in Secondary server

Any suggestions, please

Thanks a lot Tara

Dinesh

Dinesh

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-10-04 : 23:33:14

not sure, but you don't have to go to extra lengths to synchronize your logins.

issuing the command will only sychronize those orphaned logins that are present on the database and having to run them again for existing ones will not significantly affect your server performance. IMHO, you're adding extra step to a simple procedure.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources