SQL Server Blog

Error 18456 – Login Failed for User.

January 18th, 2012

Error 18456 is the generic error message for Login Failures in SQL Server. Depending on your situation this could be a simple misspelled password or the windows account does not have permission to the Instance and/or database. However I am not looking at those simple issues around this SQL Server error message. 

Error: 18456, Severity 14, State 38. Login failed for user 'DomainServiceAccountName'.  Reason : failed to open the explicitly specified database.

Read More
Blog

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.

Search