View Single Post
  #10 (permalink)  
Old June 13th, 2003, 06:09 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,022, Level: 100
Points: 72,022, Level: 100 Points: 72,022, Level: 100 Points: 72,022, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,076
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

The error indicates that the user 'HP864N\IUSR_HP864N' does not have access to the database.

To solve this, open the SQL Enterprise Manager and add this user under Security | Logins. Make sure the account has access to just the databases it is allowed to see.

Then, in the database, fine-tune the permissions for this user. It's tempting to make it DBO, but don't do that. Take some time to consider the permissions this account needs.

I usually have all my data access through Stored Procedures, so I just give execute permissions on the sprocs for this account and nothing else.

HtH,

Imar