migrating to different server

[Lena]

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

[WizKid]

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

[Lena]

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

[Franco]

Lena, the solution for your problem is here:

http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP

Regards - Franco

[Lena]

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

[Franco]

Sure, the 2 stored procedures works fine with me.
Regards - Franco

[Patience]

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

[Lena]

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

[Lena]

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

[Franco]

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.

[Lena]

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.

[WizKid]

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

[Venu]

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