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:03:48
|
| 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:51
|
| Duplicate post:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28083[/url]It is not necessary to post your question in more than one forum.Tara |
 |
|
|
|
|
|
Upgrading from SQL 6.5 to SQL 2000