Database access in SBS2000

pts.
Tags:
DataCenter
Desktop management applications
Microsoft Windows
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Maanoi
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following