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 ...
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/306b27dfc6f8f8ce/a691c85fe388e803?lnk=st&q=jocamp3%40gmail.com&rnum=1#a691c85fe388e803
Let me know.
My 2 cents: do not use the script, its easier with SSIS...
Edgardo wrote:
> 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.
> >
> >
> >
> >
> >
> >
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment