Problem :

When you install new instance SQL Server in New Server you won’t to Copy all users from Server A to the New Server B so let’s se the solution

Solution :

Microsoft make good solution about this problem  Check this link : http://support.microsoft.com/kb/918992

 

Microsoft make Script to run it on old server to generate Script for your all Users and passwords then take this Script and run it on your new server

 

Unknown's avatar

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/

One thought on “How to transfer Login and password from Server to Server in MSSQL 2008”

  1. Pingback: How to transfer Login and password from Server to Server in MSSQL 2008 « Database (SQL Server , Oracle) World

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.