Transfer SQL Logins

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

murthykalyani SSCarpal Tunnel Points: 4500 More actions · Answer 1

Can you give me more details on this what exactly you are trying to do

copied logins from which server to which server.

Does user databases previously exist or restored?

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 2

I transfer logins from sql 2000 to sql 2005 using Transfer Login Task in SSIS package.

Database are already exists on the destination server.

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 3

It sounds like you need to sync your logins.

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 4

Thanks a lot ken.

Yes the logins were not sync. I ran the script and it worked very well.

Thanks again for your help.