Transfer Logins in SQL 2005

Question

Transfer Logins in SQL 2005

srikantht.dev

SSC-Addicted

Points: 473
More actions
March 17, 2010 at 9:54 am

#212538

Hi
I trying to transfer a login my development database to production database.
I want to actually copy all the securables to production database.

Viewing 7 posts - 1 through 6 (of 6 total)

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

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

This Microsoft KB article details how to transfer logins between SQL Server 2005/2008 instances. It will require you to create a couple of objects in master on the development server.

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008[/url]

K. Brian Kelley
@kbriankelley

srikantht.dev SSC-Addicted Points: 473 More actions · Answer 2

Thank you very much for the reply.

I have fixed it. In SQL 2005 we can actually script login along with their securables. I have scripted the user and his roles and executed the same on the destination server. It worked for me.

Thanks

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

@srikanth-2

Which method did you use for it ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

srikantht.dev SSC-Addicted Points: 473 More actions · Answer 4

When you right click on the database->tasks->generate scripts

script wizard opens up and u can select the database where u want to script the logins and in the second window set all the table/view options to false and set the script login to True (default false).

In next window u can select the securables assigned to the login.

Once the script is generated u can copy and execute the same on the destination. It will create the log with same credentials.

Let me if it works for you.

Thanks

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 5

And what about USER's mapping ?

How would you do that ?

And also try that whether SQL logins are working well(with transferred encrypted passwords ) ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

srikantht.dev SSC-Addicted Points: 473 More actions · Answer 6

You can get the mapping and securables imported through the script. I tested it on my production server and i didn't had any problems and even my encrypted password logins are working fine.