migrate SQL 2008R2 username and passowrd

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?
beardog1113Asked:
Who is Participating?
 
Kalpesh ChhatralaConnect With a Mentor Software ConsultantCommented:
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
 
Kalpesh ChhatralaConnect With a Mentor Software ConsultantCommented:
Hi,

Check below Microsoft KB Article for transfer SQL Server Users

http://support.microsoft.com/kb/918992
0
 
beardog1113Author Commented:
Hi
    how can i know if the serve case-insensitive or case-sensitive ? is there any simple way to do this?
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
Kalpesh ChhatralaConnect With a Mentor Software ConsultantCommented:
you can check below link to check case sensitivity in SQL server instance.

http://stackoverflow.com/questions/1411161/sql-server-check-case-sensitivity
0
 
beardog1113Author Commented:
thank you i am trying
0
 
beardog1113Author Commented:
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
 
Kalpesh ChhatralaSoftware ConsultantCommented:
way1 and way2 depend on your situation.

master database backup and restore is easy for you.
0
 
beardog1113Author Commented:
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
 
beardog1113Author Commented:
got it and thank you
0
All Courses

From novice to tech pro — start learning today.