Wednesday, March 21, 2012

migrate SQL 2000 system users

I have installed a new SQL 2005 server and successfully moved a db from one to the other. The users from that db were also imported, but the system security was not. Users cannot access the SQL system to even attempt to login to the db. What am I missing to import/transfer/migrate the system logins from SQL2000 to SQL2005?

Thanks

David

Moving to the setup and upgrade forum.

Donald

|||

Take a look at http://support.microsoft.com/kb/918992/

Thanks,

Peter

No comments:

Post a Comment