SQL Server Logins - Migration

Hi All,

I am in the process of migrating some databases from one server to a new build.

Is there a way I can script all of my server login accounts onto the new server?

(both servers are SQL 2008 R2)

Thanks

K
techmissAsked:
Who is Participating?
 
sachinpatil10dConnect With a Mentor Commented:
Try this Generate Sql Login script for all users
0
 
techmissAuthor Commented:
That was almost too easy...thanks!

K
0
 
sachinpatil10dCommented:
Press F7 in sqlserver Managment studio
Object Explorer Details screen appears
click on SqlserverInstance>>Security>>Logins

Logins will appear

select multiple logins
Right click>>Script Login as>>Drop and Create to>>New Query Editor Window
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.