Easy Ways to Test SQL Server/SQL Azure Connection

It is incredibly easy to test the SQL Server/Azure SQL Database connectivity or firewall settings from Windows, even without SSMS (SQL Server Management Studio) or coding.

Test with ODBC Data Source

In Windows, press the Win key, type “data source”, press enter to open the ODBC Data Sources:

image

Click “Add” to add a data source:

image

Select SQL Server:

image

Fill in the server name of SQL Server/SQL Azure server name:

image

and credentials:

image

Click all the way to finish, the following dialog pops up:

image

Now click “Test Data Source” to test it:

image

Microsoft SQL Server ODBC Driver Version 10.00.10586

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

Test with UDL (Universal data link)

It can be even easier to test with UDL (Universal data link). In Windows, create an arbitrary file:

image

Rename its extension name to .udl:

image

Double click it, and fill in the connection info:

image

Click “Test Connection”, it is done:

image

14 Comments

  • thanks for the article....mine worked

  • Thanks, Simple and great trick

  • Wow!! you made it so simple .. I was thinking to create a website and use the web form to connect using a SQL connection string.. Thank you

  • شرکت بازرگانی بارمان با بهره گیری از پرسنل ، کارشناسان و کادر فنی متخصص با تجربه ای بالغ بر 10 سال سابقه در زمینه توزیع ماشین آلات و قطعات یدکی ، تعمیرگاهی و تامین تجهیزات تست عملکرد خودرو در صنایع خودرو سازی کشور ، مفتخر است به عنوان یکی از طراحان شبکه تخصصی فروش ماشین آلات و تجهیزات تعمیرگاهی در ایران بستری ایمن ، تخصصی و مناسب جهت معرفی محصولات تعمیرگاهی با شرایط مناسب برای کلیه شرکت ها ، اشخاص حقیقی و حقوقی که در زمینه ارائه سرویس و خدمات تعمیرگاهی فعالیت دارند را عرضه می نماید .

  • افضل شركة تصميم مواقع

  • https://ma-study.blogspot.com/

  • Today I am very happy to hear from you. I look forward to receiving new knowledge from you all the time.

  • Of course, your article is good enough, " slotsite" but I thought it would be much better to see professional photos and videos together. There are articles and photos on these topics on my homepage, so please visit and share your opinions.

  • I regard this article for the especially researched substance and sublime wording. I got so incorporated into this material that I couldn’t stop examining. I am awed with your work and bent. Thankful to you to such a degree.

  • Now, the big question to test is, how do you know if a slot is 'gacor'? Well, here's the tricky part; it's not an exact science. Slot machines run on random algorithms, so predicting when one will go 'gacor' is like predicting the weather (you might get it right, but it's mostly luck).

  • I've been looking for photos and articles on this topic over the past few days due to a school assignment, <a href="https://toolbarqueries.google.gm/url?sa=t&url=https%3A%2F%2Fwww.mtclean.blog/">slotsite</a> and I'm really happy to find a post with the material I was looking for! I bookmark and will come often! Thanks :D

  • I've been troubled for several days with this topic. <a href="https://toolbarqueries.google.gl/url?sa=t&url=https%3A%2F%2Fwww.mtclean.blog/">baccaratcommunity</a>, But by chance looking at your post solved my problem! I will leave my blog, so when would you like to visit it?

  • The assignment submission period was over and I was nervous, <a href="https://toolbarqueries.google.gg/url?sa=t&url=https%3A%2F%2Fwww.mtclean.blog/">casinocommunity</a> and I am very happy to see your post just in time and it was a great help. Thank you ! Leave your blog address below. Please visit me anytime.

  • I am very impressed with your writing <a href="https://toolbarqueries.google.ge/url?sa=t&url=https%3A%2F%2Fwww.mtclean.blog/">majorsite</a> I couldn't think of this, but it's amazing! I wrote several posts similar to this one, but please come and see!

Add a Comment

As it will appear on the website

Not displayed

Your website