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.
| Author |
Topic |
|
Gyto
Posting Yak Master
144 Posts |
 Posted - 2009-06-23 : 07:33:05
|
| Hi there,I have an server running SQL Server 2000 and another running 2005. I will be copying a database from the 2000 server to the 2005 server (probably using detach/reattach).I'm sure this has probably been asked many times before but I can't seem to find a definitive answer....so....what would be the best way to transfer the database logins over too? The 2 servers will not necessarily be connected at the time so I think I'm right in saying the SQL Server Integration Services transfer Logintask is probably not an option?I am also using Enterprise Manager as opposed to Management Studio.Any thoughts?Thanks,Matt |
|
|
bouzahme
Starting Member
1 Post |
Posted - 2009-06-23 : 12:54:14
|
| Hi,Check the following, I always use the proc inside the article.[url]http://support.microsoft.com/kb/246133/en-us[/url]regards |
 |
|
|
Sqlbuddy
Starting Member
27 Posts |
Posted - 2009-06-23 : 12:59:08
|
| Hi Gyto, The link provided by Bouzahme works absolutely fine. I also use that sp for transfering the logins from SS2K to SS2K5.Best RegardsSQLBuddy |
|
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2009-06-24 : 04:59:28
|
| Hi guys,Thanks for that, looks good....can I just confirm - is it 'Method 2' off that page you use?Cheers |
|
|
|
|
|
|
Migrating logins from SQL Server 2000 to 2005