[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server Logins - Migration

Posted on 2011-10-18
3
Medium Priority
?
313 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:techmiss
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
sachinpatil10d earned 2000 total points
ID: 36985300
Try this Generate Sql Login script for all users
0
 

Author Closing Comment

by:techmiss
ID: 36985317
That was almost too easy...thanks!

K
0
 
LVL 9

Expert Comment

by:sachinpatil10d
ID: 36985322
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question