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.

Tweet
Pin
Share
0 Shares
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
Recent Posts
SQL Server 2025 : An AI-ready Enterprise DatabaseData Saturday Event CreationEnabling SQL Agent Service after Upgrading from ExpressSSMS Tips and TricksArc Enabled Data Services – 12
Categories
AlwaysOn Availability Groups Arc Data Services Availability Groups Azure Azure Data Studio CosmosDB Data Database DevOPs Database Lifecycle Management DevOPs Disaster Recovery DLM General High Availability JSON Kerberos Performance Power BI Presentations Reporting Services Security Service Broker Service Packs SMC SQL SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server 2022 SQL Server 2025 SQLServer SQLServerCentral T-SQL T-SQL Tuesday TSQL Uncategorized
Archive
  • 2024
  • 2023
  • 2022
  • 2021
  • 2020
  • 2019
  • 2018
  • 2017
  • 2016
  • 2015
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010