SQLServerCentral / Discuss Content Posted by Gregory Larsen / Article Discussions / Article Discussions by Author / Migrating Logins To Another Server / Latest Posts

RE: Migrating Logins To Another Server

kwoznica — Fri, 11 Mar 2011 13:44:14 GMT

is this still possible with sql server 2005/2008 with the new DMV's?

RE: Migrating Logins To Another Server

joel_langlois — Wed, 30 Sep 2009 09:22:34 GMT

Hi,Does using the script from [b]sp_help_revlogin [/b]also copy the user's permisions?Thanks,Joel

RE: Migrating Logins To Another Server

Chris Bjorson — Tue, 05 Oct 2004 07:07:00 GMT

When using the script to transfer logins and passwords from one server to another. After doing so... Does the logins and passwords still appear on the server transfering from??? I am doing a parallel install and need to keep the production database logins and passwords still intact.

Thanks

Chris

RE: Migrating Logins To Another Server

jack-64275 — Thu, 30 Sep 2004 06:04:00 GMT

This would be a lot better if it was fit to screen size rather than having to scroll back and forth to read it...

RE: Migrating Logins To Another Server

David.Poole — Wed, 01 Oct 2003 01:49:00 GMT

Thats the baby. Thanks

RE: Migrating Logins To Another Server

Allen Cui-55137 — Tue, 30 Sep 2003 10:26:00 GMT

Is sp_change_users_login you are looking for?

RE: Migrating Logins To Another Server

David.Poole — Tue, 30 Sep 2003 09:39:00 GMT

Can anyone remember the SP that fixes orphaned users?I seem to remember that if the login name and user name were the same it assigns a matching SID.

RE: Migrating Logins To Another Server

Greg Larsen — Tue, 30 Sep 2003 09:00:00 GMT

I agree it would be nice to transfer the default database. As the script comes from Microsoft it does not set the default database, and that is what I presented in the article.Normally if I am only moving one database I modify the sp_help_revlogin SP to only select logins if they are associated with the database I am moving and I add "execute master..sp_defaultdb " commands to the SP to make sure the default db get set.It could also be modified to determine the default database and set it appropriately. This would be a good enhancement to this script.Gregory A. Larsen, DBAContributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here:http:www.sqlservercentral.com/bestof/purchase.aspNeed SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

RE: Migrating Logins To Another Server

Greg Larsen — Tue, 30 Sep 2003 08:51:00 GMT

When you transfer master all the logins will come across so you would not have to run this script. This script is used to copy logins and passwords without restore the master database.Gregory A. Larsen, DBAContributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here:http:www.sqlservercentral.com/bestof/purchase.aspNeed SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

RE: Migrating Logins To Another Server

Rabenklau — Tue, 30 Sep 2003 07:17:00 GMT

It does not transfer the default database though.

RE: Migrating Logins To Another Server

John Campbell-96530 — Tue, 30 Sep 2003 06:03:00 GMT

I just use the script to transfer the logins from a DEC ALPHA SQL 7 server to a new Intel SQL 2000 server with no problems. I was unable to use the Transfer Logins DTS job on this combination. Timely ... Absolutely :>)

RE: Migrating Logins To Another Server

StefanJ — Tue, 30 Sep 2003 03:38:00 GMT

I have experienced problems transferring logins so this article will be very useful if I have to do it in a live situation. Just one clarification. Would it be necessary to run this script if I restored backups to a completely new server. I imagine the order would be to transfer the system databases first followed by the user databases. Would the logins and users be correctly linked after the restore?

Migrating Logins To Another Server

Greg Larsen — Sun, 28 Sep 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp