Solved

migrate SQL 2008R2 username and passowrd

Posted on 2013-12-18
9
383 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

 

Author Comment

by:beardog1113
ID: 39735429
thank you i am trying
0
 

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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

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.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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…

622 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