We help IT Professionals succeed at work.

SQL Server Insufficient Permission

Login failed for user 'WINDOWUSER'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.0.0.00].

I've dropped and recreated the account and I've updated the orphaned records; however I'm still getting the above error message.  Any thoughts/help is greatly appreciated.
Comment
Watch Question

>> Failed to open the explicitly specified database.  <<
The default database for the login does not exists anymore. Just change it.
Commented:
Can you double check you're connecting to the database you want. Connection string?

Author

Commented:
When I give the account "sysadmin" permissions, everything works fine.  Thoughts?

Commented:
thats because sysadmin has less limits
- check which database is mentioned in connect string (or default database)
- trace (profiler) conections and sql-actions by that user when he can work (as sysadmin) so you can see what databases it tries to connect