Skip to content

Latest commit

 

History

History
15 lines (9 loc) · 632 Bytes

sql-diagnostic-connection.md

File metadata and controls

15 lines (9 loc) · 632 Bytes

SQL Diagnostic Connection

When troubleshooting SQL if the server is unresponsive and you are unable to connect via SSMS then you can use a Diagnostic connection.

Microsoft Documentation Link - Diagnostic Connection for Database Administrators

Steps for connection

  • Open SSMS

  • Close the Login Window

  • Click File > New > Database Engine Query

  • append admin: to the server name and login with valid SA level credentials

    example gif