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.
nitayalevetteAsked:
Who is Participating?
 
jorgedeoliveiraborgesCommented:
>> Failed to open the explicitly specified database.  <<
The default database for the login does not exists anymore. Just change it.
0
 
jogosCommented:
Can you double check you're connecting to the database you want. Connection string?
0
 
nitayalevetteAuthor Commented:
When I give the account "sysadmin" permissions, everything works fine.  Thoughts?
0
 
jogosCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.