Solved

migrate SQL 2008R2 username and passowrd

Posted on 2013-12-18
9
377 Views
Last Modified: 2013-12-23
Hi
    i have SQL instanc run on server A, now, i setup other windows and SQL 2008 on server B, i would like migrate all database and username password to new server B, for database, i can backup and restore, how can i migrate username and password?
0
Comment
Question by:beardog1113
  • 5
  • 4
9 Comments
 
LVL 16

Assisted Solution

by:Kalpesh Chhatrala
Kalpesh Chhatrala earned 500 total points
ID: 39728595
Hi,

Check below Microsoft KB Article for transfer SQL Server Users

http://support.microsoft.com/kb/918992
0
 

Author Comment

by:beardog1113
ID: 39728653
Hi
    how can i know if the serve case-insensitive or case-sensitive ? is there any simple way to do this?
0
 
LVL 16

Assisted Solution

by:Kalpesh Chhatrala
Kalpesh Chhatrala earned 500 total points
ID: 39728659
you can check below link to check case sensitivity in SQL server instance.

http://stackoverflow.com/questions/1411161/sql-server-check-case-sensitivity
0
 

Author Comment

by:beardog1113
ID: 39735429
thank you i am trying
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:beardog1113
ID: 39737249
Hi I backup the master database and restore it on my new SQL server, all user name and password has migrated, is there any different with http://support.microsoft.com/kb/918992 ? i mean, which way is best for migrate username and password, when we need way1 and when we use way 2 ?
0
 
LVL 16

Expert Comment

by:Kalpesh Chhatrala
ID: 39737331
way1 and way2 depend on your situation.

master database backup and restore is easy for you.
0
 

Author Comment

by:beardog1113
ID: 39737340
Hi, What does mean "my situation" ? the script use for senior DBA and the master use for junior DBA ? if yes, What is the advantage of script ?
0
 
LVL 16

Accepted Solution

by:
Kalpesh Chhatrala earned 500 total points
ID: 39737342
if junior DBA has not right to Restore the database then  you can execute script in junior dba credentials.

some time backup / restore database create a problem at that time script is useful.
0
 

Author Comment

by:beardog1113
ID: 39737390
got it and thank you
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now