SQL Server Performance Forum – Threads Archive

Transferring logins.

Does anybody know how to transfer logins between instances in SQL 2005. KB246133 used the two procs sp_hexadecimal and sp_help_revlogin. Since the table master..sysxlogins does not exist in SQL 2005, is there any other way to transfer logins…..I am not interested in SSIS……this throws lots of errors. Thanks, StarWarsBigBang

---

I have been successful in using the procedure in KBAhttp://support.microsoft.com/kb/918992 link. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

You missed the following part when you were reading KB246133 … How to transfer logins and passwords between instances of SQL Server 2005
For more information about how to transfer the logins and passwords between instances of SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:
918992 http://support.microsoft.com/kb/918992/) How to transfer the logins and the passwords between instances of SQL Server 2005 MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

Thanks MohammedU 918992 works. Thanks, StarWarsBigBang

---

Thats the reason referred that KBA specifically. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>