Database access

[Manoi]

Hi,
I've added recently a new user to our SBS 2000 domain. Then added this user as database user to our database using the Enterprise Manager. 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.

 

[tran008]

Is the SQL server using Mixed mode or Windows Authentication?

 

[Manoi]

SQL is set to use Windows Authentication only.

 

[dbomrrsm]

try with sp_grantdbaccess

This example adds an account for the Windows NT user Corporate\GeorgeW to the current database and gives it the name Georgie.

EXEC sp_grantdbaccess 'Corporate\GeorgeW', 'Georgie'



[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[Catadmin]

If she was added without a default database and the next one was added with one, this might also explain the problem.

Additionally, remember SQL goes by most restrictive permissions. Verify she isn't part of a group that has been previously mapped to SQL with Deny permisions on the database in question.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!