Solved

migrate SQL 2008R2 username and passowrd

Posted on 2013-12-18
9
380 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

856 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