Database access in SBS2000
Hi,
I've added recently a new user to our SBS 2000 domain. Then added this user to our database using the Enterprise Manager, so she can use it. When she tries to open the database, the following error message appears: "You don't have access rights to the database" (translating from dutch). I cannot find where the problem is, especially that I have added another user just a week earlier following same steps without any problems. Any ideas how to solve this problem? Thanks in advance.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 2, 2005 8:47 AM
UPDATED:
March 2, 2005 11:56 AM
Answer Wiki:
Not uncommon - If you look at the security entries for SQL server you will find your user, but when you look in the database itself the user won't have access granted.
In QueryAnalyser you can access the stored procedure dbo.sp_change_users_login (found in the master database) and apply it against your user and the database that is denying access.
[change to reflect your database name]
sp_change-users-login, 'Auto_Fix', 'database'
should update the user list and restore access.
Did you do both adds from the same workstation and same login. This problem usually happens when one of the adds was done without SA access.
To see all answers submitted to the Answer Wiki: View Answer History.
Hi Howard2nd,
Yes, you are correct this maybe the problem’s cause. I am not so familiar with SQL admin, will you please guide me how to do the Auto Fix command? Thanks in advance