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 |
|
bgardne
Starting Member
2 Posts |
 Posted - 2003-07-29 : 13:04:51
|
| Hello,I've been tasked with upgrading a SQL Server 6.5 to SQL Server 2000. The old SQL 6.5 server is a BDC on an NT 4.0 Domain. The new SQL Server 2000 is installed on a Windows 2000 Stand alone server (can't make it a DC). My question is this: How do I transfer logins and passwords from the old 6.5 server to the new 2000 server? I've been using the 'SQL Server Upgrade Wizard' with some success, but it does report the following error: =============================================The following logins are missing from master, so your upgrade may fail. It is highly recommended that you verify that all your 6.5 sysusers have valid syslogins in master before you continue.=============================================<list of users follows>Do I have to manually add these new users, with new passwords, or is there another way to import them from the old server?Any help, article references, etc. would be greatly appreciated.Regards,Bruce Gardner |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-29 : 13:18:24
|
| I wrote a stored procedure called isp_Transfer_Logins. It uses linked servers, but as long as you create the linked server on the SQL 2000 machine and point it to the 6.5 machine, it should work. You will have to change the stored procedure a little bit for it to work for you. Just do a forum search on isp_Transfer_Logins.Tara |
 |
|
|
|
|
|
Upgrading from SQL 6.5 to SQL 2000