RSS

How to transfer Login and password from Server to Server in MSSQL 2008

03 Mar

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

 

 
1 Comment

Posted by on March 3, 2013 in SQl server Administration

 

One response to “How to transfer Login and password from Server to Server in MSSQL 2008

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s