May 21, 2004 at 1:31 pm
Any suggestions on the best way to move SQL Server 6.5 logins to another server?
"Keep Your Stick On the Ice" ..Red Green
May 24, 2004 at 8:28 am
This is most likely unsupported and I'm reaching back to remember how well it worked, but...
v65 was more "friendly" in terms of hacking the system tables. So we did a few things like moving database, by directly making changes to the tables. Not sure about the logins, but I'd probably attempt this.
select the data from syslogins that you need into another table. bcp out/in to the new server. Then add the logins directly to the master.syslogins table. You'll need to do master.sysusers as well for the matching. That should get your logins working. Be sure you reboot after this and be sure other logins and such are working. Best to do this with a fresh v65 install.
Is there a reason you can't move to v2000 in v65 compatability mode?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply