November 9, 2004 at 11:35 am
I am trying to move my databases from a SQL7.0 machine to a SQL2000 machine.
I simply restored the .bak files from the old machine to the new one and everything looks fine until someone tries to use an application that requires a login. Then it gives me an access denied error.
When I look for the users, they are all listed under the roles instead of the users. ie. under database owner role I can see all my users. When I try to add them to the various databases it says they already exist. The only accounts that work are newly created ones or the sys admin acounts.
I've tried to remove all the logins and start over, but I can't remove them from the pub role.
November 9, 2004 at 12:44 pm
What's happened is the database users were created with the database, but they aren't associated with a login on the new server. You can use sp_change_users_login to associate them. Look it up in BOL to see the details.
Greg
Greg
November 10, 2004 at 2:24 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply