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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Transferring passwords from 6.5 to 7.0

Author  Topic 

AGLC_DBA
Starting Member

2 Posts

Posted - 2000-11-21 : 11:18:01
Upgrading from SQL 6.5 to SQL 7.0, not using NT authentication yet (that will be phase 2), I have a need to transport logins with passwords intact.

I have done this before and it works great if it's a clean global transfer and all databases go to one server at the same time. The challenge comes in when I want to distribute the databases over more than one server, in other words, some of them on server A and some of them on server B, etc.

Any good ideas will be appreciated.

Thank you.
   

- Advertisement -