Login Failed for User '' - SQL Server

  • Article

Periodically, I have seen issues with connecting to a remote SQL Server from SQL Server Management Studio, Asp.Net applications, ODBC connections, etc.   Often times this is specific to a machine and not a complete on/off issue with SQL Server security.   Often you can connect to other SQL servers but not particular ones.  The issue could stem from stored username/passwords for a specific computer.   Here is how you may be able to fix it:

  1. Goto User Accounts in Control Panel
  2. Click on the Advanced tab
  3. Click on Manage Passwords
  4. In the list, select the machine name and either edit the properties and correct the stored username and password or remove all together

Your all set.  You should now be able to connect to your SQL Server!