Sunday, March 25, 2012

Database Mirroring and Login Transfer

Hi All:
I am running SQL 2005 EE SP1 and have implemented database mirroring and
have a mix of SQL accounts and Windows accounts. . Is there a way to
automatically synchronize logins between the servers...including additions,
deletions, roles, passwords, permissions and SIDs. I know Mirroring has
nothing built in for this but am hoping someone has figured something out.For additions, I use sp_help_revlogin to synchronize logins between servers,
the procedure is described in the following article:
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
"Jim Norton" wrote:

> Hi All:
> I am running SQL 2005 EE SP1 and have implemented database mirroring and
> have a mix of SQL accounts and Windows accounts. . Is there a way to
> automatically synchronize logins between the servers...including additions
,
> deletions, roles, passwords, permissions and SIDs. I know Mirroring has
> nothing built in for this but am hoping someone has figured something out.
>
>
>|||Check my post about this. I had the same problem some days ago ...
8e803" target="_blank">http://groups.google.com/group/micr...38
8e803
Let me know.
My 2 cents: do not use the script, its easier with SSIS...
Edgardo wrote:[vbcol=seagreen]
> For additions, I use sp_help_revlogin to synchronize logins between server
s,
> the procedure is described in the following article:
> How to transfer logins and passwords between instances of SQL Server
> http://support.microsoft.com/kb/246133
>
> "Jim Norton" wrote:
>sql

No comments:

Post a Comment