Right now just found out that some login in the SQL server 2005 with SP2 mirror DR site do not have the respective login from primary mirror partner.
I can do this
to manually transfer sql server login to the DR parnter.
1) Anyway to automate the whole process?
2) I recall that the database permission, will goes with the database backup and restore process during the mirror creatino process ? so in this case, we only need to find out only the SQL login transfer script (by http://support.microsoft.com/kb/918992
) and apply to the DR mirror parnter?
3) Can the SQL srever 2012 / 2014 DAG group automate this ? it mirror the MS SQL system database too ?
4) or must use SSIS for that? any step by step guide to implement this kind of SSIS task on SQL server 2005 with SP2?
I find out this: http://www.sqlsoldier.com/wp/sqlserver/transferring-logins-to-a-database-mirror
, any one tried that before ? can it copy the database role and permisson of the missing SQL login to the DR server as well ? and it work with SQL server 2005 and all version after?
so usage is dba_CopyLogins <dr server name>; on primary server?
and it will only copy the MISSING login for that instead of recreate all logins or create all but with error message that the same login already exists on DR server ?
please suggest what is your existing method .