MSSQL Failed Logins

Troubleshooting

Testing a connection without installing any SQL tools...

  • Create an empty text file and give it a .udl extension

  • Double-click the file and the window shown on the right should appear.

  • Enter the login information you want to test

If you use "Windows NT Integrated security" it will attempt to login to the target SQL Server as the use you are currently logged in as.

  • Select a database

  • Click "Test Connection"

Auditing