There are occasional times when we need to test connectivity from a machine back to SQL Server without installing SSMS or any tool. There are many ways to do it but the question is how easily can this be done? This is often asked in DBA interviews also, “How to verify sql server connection without SSMS?” or “How to find installed sql server instance names on a machine without SSMS or any tools?”
Answer: Using UDL (Universal Data Link) file.
- RUN → Notepad
- Once the notepad is opened, File → Save As… (Do not type anything in the notepad)
- Choose the path → Save as type: All Files (*.*) → File name: Test.udl (File name can be anything but the extension must be .udl)
- Double click on the udl file