Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

migrate SQL 2008R2 username and passowrd

Posted on 2013-12-18
9
Medium Priority
?
384 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 2000 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 2000 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

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 2000 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
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.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

705 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