-
migrating to different server
Hello!
We are planning migrating to different server.
I know the answers how to migrate all jobs and DTS packages.
But the only question I have is "How to migrate logins and passwords?"
What is the best way to transfer logins?
Can't you just export syslogins table into text file and then import it into the new server?
Thank you
Lena
-
migrating to different server (reply)
Why don't you script out the logins and execute the script on the new server.
------------
Lena at 6/27/01 4:08:23 PM
Hello!
We are planning migrating to different server.
I know the answers how to migrate all jobs and DTS packages.
But the only question I have is "How to migrate logins and passwords?"
What is the best way to transfer logins?
Can't you just export syslogins table into text file and then import it into the new server?
Thank you
Lena
-
migrating to different server (reply)
Can you please be more specific?
------------
WizKid at 6/27/01 5:22:17 PM
Why don't you script out the logins and execute the script on the new server.
------------
Lena at 6/27/01 4:08:23 PM
Hello!
We are planning migrating to different server.
I know the answers how to migrate all jobs and DTS packages.
But the only question I have is "How to migrate logins and passwords?"
What is the best way to transfer logins?
Can't you just export syslogins table into text file and then import it into the new server?
Thank you
Lena
-
migrating to different server (reply)
Lena, the solution for your problem is here:
http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP
Regards - Franco
-
migrating to different server (reply)
Franco
Thanks for your help.
Just for curiosity did you try this solution and if yes did it work fine?
I'm talking about using 2 stored procedures provided in this article.
Thanks
Lena
------------
Franco at 6/28/01 10:58:18 AM
Lena, the solution for your problem is here:
http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP
Regards - Franco
-
migrating to different server (reply)
Sure, the 2 stored procedures works fine with me.
Regards - Franco
-
migrating to different server (reply)
It might be better for you to try the options on your Test Environment first before you apply your chosen option on a production server. Good Luck!!!
------------
Lena at 6/28/01 11:24:20 AM
Franco
Thanks for your help.
Just for curiosity did you try this solution and if yes did it work fine?
I'm talking about using 2 stored procedures provided in this article.
Thanks
Lena
------------
Franco at 6/28/01 10:58:18 AM
Lena, the solution for your problem is here:
http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP
Regards - Franco
-
migrating to different server (reply)
Thank you.
I hope it will work for me also.
------------
Franco at 6/28/01 11:40:23 AM
Sure, the 2 stored procedures works fine with me.
Regards - Franco
-
migrating to different server (reply)
OOPs
I forgot to ask you.
Do you have to run this stored procedure prior to restoring user databases or after?
Thanks
Lena
------------
Franco at 6/28/01 10:58:18 AM
Lena, the solution for your problem is here:
http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP
Regards - Franco
-
migrating to different server (reply)
The order is not important. It is important to have NO logins on the new Server (the one who need to receive the logins and passwords), otherwise you need to first delete all them.
-
migrating to different server (reply)
Thank you!!!!
------------
Franco at 6/28/01 11:54:27 AM
The order is not important. It is important to have NO logins on the new Server (the one who need to receive the logins and passwords), otherwise you need to first delete all them.
-
migrating to different server (reply)
Lena,
Here is how...(SQL 7.0)
In EM, expand the database to see all tables in the right pane.
Right click on any table and select "All Tasks --> Generate SQL Scripts".
Under "Options" tab page CHECK the first two options in "Security Scripting Options" group( "Script Database users and database roles" and "Script SQL server Logins" ).
Back in the "General" tab-page, click "Preview".
Copy the script and remove the "DROP" (at the begining) and "CREATE (at the end) statements. You now have the scripts for LOGINS, USERS and thier ROLES.
good luck...
- HemantH
------------
Lena at 6/28/01 10:14:55 AM
Can you please be more specific?
------------
WizKid at 6/27/01 5:22:17 PM
Why don't you script out the logins and execute the script on the new server.
------------
Lena at 6/27/01 4:08:23 PM
Hello!
We are planning migrating to different server.
I know the answers how to migrate all jobs and DTS packages.
But the only question I have is "How to migrate logins and passwords?"
What is the best way to transfer logins?
Can't you just export syslogins table into text file and then import it into the new server?
Thank you
Lena
-
migrating to different server (reply)
Lena,
The two stored procedures work perfect , I tried it a couple of times..
Hemant,
U can script the logins the way u mentioned but , the passwords for the Standard logins will be "null"
Thanks,
Venu
------------
WizKid at 6/28/01 12:50:50 PM
Lena,
Here is how...(SQL 7.0)
In EM, expand the database to see all tables in the right pane.
Right click on any table and select "All Tasks --> Generate SQL Scripts".
Under "Options" tab page CHECK the first two options in "Security Scripting Options" group( "Script Database users and database roles" and "Script SQL server Logins" ).
Back in the "General" tab-page, click "Preview".
Copy the script and remove the "DROP" (at the begining) and "CREATE (at the end) statements. You now have the scripts for LOGINS, USERS and thier ROLES.
good luck...
- HemantH
------------
Lena at 6/28/01 10:14:55 AM
Can you please be more specific?
------------
WizKid at 6/27/01 5:22:17 PM
Why don't you script out the logins and execute the script on the new server.
------------
Lena at 6/27/01 4:08:23 PM
Hello!
We are planning migrating to different server.
I know the answers how to migrate all jobs and DTS packages.
But the only question I have is "How to migrate logins and passwords?"
What is the best way to transfer logins?
Can't you just export syslogins table into text file and then import it into the new server?
Thank you
Lena
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|