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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-05 : 00:23:54
|
| Robert writes "We are currently upgrading from 6.5 to 7.0 on a seperate server.Transferring the ID and Password is critical for us.A link was setup from 7.0 to the 6.5 server, and I am able to Select in the syslogins table of the 6.5 server.We tried to use sp_addlogin with the 6.5 password and the skip_encryption_old option. It is abending because of weird characters like !@$.We have tried with CONVERT(VARBINARY(32),password) and the skip_encryption option. We are close (looks the same), but it does not work (not same encyption algorithm).Do you have any scripts or documentation or suggestion to do this.Many thanks for your help" |
|
|
|
|
|
Upgrade ID and Password