An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.
One of the most common issues faced while connecting to a SQL Server instance is "Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)". In addition to the Error No. SQL Server will provide an Error State no. which will be helpful…