Transferring Logins between SQL 7.0 Servers 1

[GWPhoenix]

I need to transfer large databases between SQL Servers. So far it works quite well using DTS, but the Login passwords in the destination database have null passwords.

I know this is how it works according to Microsoft Support, but has anyone found a workaround on this? I am dealing with nearly 1000 passwords and have limited time!

 

[tlbroadbent]

I don't follow your explanation. If the passwords are NULL (very bad procedure!), why is that causing you a problem. Just use the login without a password. What did I miss in your explanation? Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[GWPhoenix]

On the original server, we have about 1000 users with login passwords and have to move everything onto a new server. The passwords are not null on the old server, but in the transfer process, become null on the new system.

I am looking for a way to avoid having to key in so many passwords.

 

[tlbroadbent]

Now I understand. Neil Boyle has an article on SWYNK.com that explains how to transfer logins between server.

http://www.swynk.com/friends/boyle/fixingbrokenlogins.asp

Hope this helps. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes