How To Test A SQL Server Connection
Read Time:26 Sec
There is an easy way to test your SQL Server connection when running Windows without any special software.
I found this solution on StackOverflow.
- Add a new blank text file to the Desktop
- Change the file extension to “udl” (Universal Data Link)
- Double-click the file you just created
- By default the connection will use the Microsoft OLE DATABASE Provider for SQL Server
- Configure the settings on the Connection tab
- ServerName or ServerName\Instance ame
- Login method
- Select a database
- Click [Test Connection]
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating