Troubleshoot Connectivity/Login failures (18456 State x) with SQL Server

I know that there are lot of articles over the internet world with this topic… But this article is from my perspective which has detailed troubleshooting steps… The main problem with troubleshooting connectivity issues with SQL Server is because the error message returned to client is almost generic and incase of login failures, the state…

6