transfer logins & passwords from SQL 2000 to 2008

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

transfer logins & passwords from SQL 2000 to 2008

Author

Topic

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2010-08-26 : 19:06:49

Dear All,

Can you please let me know how to transfer logins and passwords from SQL Server 2000 to SQL Server 2008.Also i have gone through the site " http://blog.netnerds.net/2009/01/migratetransfer-sql-server-2008200520007-logins-to-sql-server-2008/ "

Please Advice..

Thanks & Regards
Ravi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-26 : 19:29:26

Here's what I use: http://www.sqlmag.com/article/query-analyser/sql-server-login-transfer.aspx

It's a simple copy/paste type thing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2010-08-26 : 19:40:33

quote:
Originally posted by tkizer

Here's what I use: http://www.sqlmag.com/article/query-analyser/sql-server-login-transfer.aspx

It's a simple copy/paste type thing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Dear Tara,

Thank you for your prompt reply,Please let me know is it applicable for transferring logins from 2000 to 2008..

Thanks & Regards
Ravi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-27 : 00:06:57

Yes it is.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2010-08-27 : 20:04:25

quote:
Originally posted by tkizer

Yes it is.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Hi Tara,

I have tested and executed Its working fine for me..
Its an honour 4 me 2 have a friend like u
thanks 4 everything Tara..

Thanks & Regards
Ravi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-27 : 23:52:22

You're welcome.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources