Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
If you have an app connecting to a Microsoft SQL data source, you may need to confirm that the source (app) server can successfully connect to the SQL server.
This guide teaches you the two methods for performing this test.
Option 1: Test Connection with ODBC Data Sources Driver
Microsoft provides an app on every Windows computer for making SQL test connections. The app is called “Set up ODBC data sources”.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Here are the steps to use this app to test whether you can successfully connect to a Microsoft SQL server.
#1 Best Overall
AINOPE USB Extension Cable 2Pack 6.6FT USB 3.0 Extender Male to Female Grey | 5Gbps High Data Transfer Cord for Printer Webcam Flash Drive Hard Drive Hub Keyboard Mouse Camera Playstation Xbox and More
- REINFORCED SR CABLE JOINT:AINOPE USB 3.0 extension cable with test of 400,000+ bend, the special SR design makes the cable joints more sturdy. The flexible and wear-resistant armor nylon braided material offers stronger protection. The Included sticky buckles helps to shorten the length and keeps the USB 3.0 extension cable in an organized manner, no tangling worries and effectively prolong the service life.
- UPGRADED CONNECTOR:This USB extension cable with all-metal shell and aluminum alloy connector, provides you fancy texture with good hand-feeling, and ensure the extreme durability. Also constructed with multiple layers of shielding to minimize interference, corrosion-resistant , effectively prolong the cable service life.
- USB3.0 FAST CHARGING & DATA SYNCING:Charging and data transmission two in one, Our USB 3.0 extension cable is 10X faster than USB2.0 cable, also, this USB 3.0 extension cable backwards compatible with USB 2.0 and USB 1.1 standard devices
- UNIVERSAL COMPATIBILITY:You can using this cable to extends your usb connection to your computer, as well as a variety of USB peripherals such as Hubs, Printers, Card Readers, Bluetooth Adapters, USB Flash Drives, Scanners, Hard Drives, Mouse, Keyboard without any hysteresis or loss of data.
- WORRY-FREE SERVICE: If you have any questions about our product, please feel free to contact with our reliable customer service, we will reply you within 24 hours. Package: USB 3.0 Extension Cable Cable*2
- Sign in to the server or computer you’re testing the connection from. Then, search for and open the Control Panel.
- When Control Panel opens, search odbc and open “Set up ODBC data source” – there is a 32-bit and 64-bit version – select the one you want to use.
- When the ODBC Data Source Administrator opens, click the System DSN tab. Then, click Add.
- Select SQL Server and click Finish.
- Enter a name for the connection in the Name field. Then, enter the name or IP address of the Microsoft SQL server you want to connect to in the Server field – click Next to continue.
- Finally, select the credential type to use for the connection and click Next.
The first option, “With Windows NT authentication…” connects to the SQL server using the logged-in credential. On the other hand, option 2, “With SQL Server…” connects with an SQL login. If the connection is successful, you will receive a confirmation
Option 2: Test SQL Connection Using a .udl File
If you do not want to use the inbuilt ODBC connector app, you can create any file name with the .udl extension. Then, use the file to test your connection.
The three subsections below explain the detailed steps.
Rank #2
Cable Matters 5Gbps USB 3.0 Cable, USB A to B Cable, 6ft, Black | Type-B 3.0 Connector, Compatible with Hard Drive Enclosures / Built-in Hubs
- Versatile Device Connectivity: This high-performance USB A to USB B cable easily connects desktop external hard drives, powered USB hubs, USB docking stations, 3.5-inch hard drive enclosures, scanners, and monitors with a Type-B USB 3.0 port to your computer for fast and efficient file transfer. Note: This is a USB-A to USB-B 3.0 cable and will NOT work with USB 2.0 Type-B ports.
- Faster Data Transfer Speeds: Enjoy SuperSpeed USB 3.0 data transfer rates of up to 5 Gbps, 10 times faster than USB 2.0, ensuring quick and reliable performance with this USB 3 cable.
- Enhanced Durability and Easy Use: This USB B to USB A cable is engineered with molded strain relief connectors for extra durability, while the grip treads make it easy to securely plug and unplug without hassle.
- Superior Performance and Reliability: Featuring gold-plated connectors, bare copper conductors, and foil & braid shielding, this USB Type B 3.0 cable ensures optimal performance, error-free data transmission, and fast charging speeds.
- Broad Compatibility with Popular Devices: The USB 3.0 Type B cable is compatible with Fujitsu ScanSnap iX500 scanner, Dell S2340T monitor, Dell USB 3.0 docking station, HP USB 3.0 port replicator, and Western Digital (WD) and Seagate desktop USB 3.0 external hard drives equipped with a Type-B USB 3.0 port.
Step 1: Change File Explorer Settings
- Right-click the Windows Start menu and select File Explorer.
- Click the View tab, then the Options drop-down, and select “Change folder and search options.”
- Finally, on the Folder Options screen, click the View tab and uncheck the Hide extensions for known file types option – then click OK.
Step 2: Create a .udl File
- From the computer you want to test the connection from, open Notepad. Then, click File -> Save As.
- Next, select the folder you want to save the file. Then, enter any name with the .udl extension.
You MUST enter the name in double quotation marks. Here is a sample that I am using for my demonstration. Finally, click Save to save the file.
"SQLconnection.udl"
Step 3: Test an SQL Connection Using the .udl File
- Open the location you saved the file in step 1 and double-click it.
- On the “Data link properties” settings that open, enter the name or IP address of the SQL server. Then, select the login type and enter the sign in credentials.
After entering the details, click “Test Connection.”
The first option, “Use Windows NT Integrated security” connects to the SQL server using the logged-in credential. The second option, “Use a specific user name and password” allows you to specify a different username and password.
Conclusion
Testing connections to a Microsoft SQL database server is an essential troubleshooting step in trying to figure out why an app may be having trouble working as expected. I have shown two methods to complete this essential troubleshooting step in this guide.
Recommended Free Tools
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Specifically, I explained how to test a Microsoft SQL connection using the built in ODBC Data Sources Driver and by using a .udl file.
Rank #3
Sale
AINOPE USB Extension Cable 10FT USB 3.0 Extender Male to Female Cord Grey | 5Gbps High Data Transfer for Printer Webcam Flash Drive Hard Drive Hub Keyboard Mouse Camera Playstation Xbox and More
- 10FT PERFECT LENGTH: With the perfect 10ft length, you can play the game freely ,or lie on the sofa to use your devices for video while you are charging.What's more,you can also extend your surveillance camera (please make sure the camera interface is USB A port). Perfect Length for your easy life-use.
- REINFORCED SR CABLE JOINT:AINOPE USB 3.0 extension cable with test of 20,000+ bend, the special SR design makes the cable joints more sturdy. The flexible and wear-resistant armor nylon braided material offers stronger protection. The Included sticky buckles helps to shorten the length and keeps the USB 3.0 extension cable in an organized manner, no tangling worries and effectively prolong the service life.
- UPGRADED CONNECTOR:This USB extension cable with all-metal shell and aluminum alloy connector, provides you fancy texture with good hand-feeling, and ensure the extreme durability. Also constructed with multiple layers of shielding to minimize interference, corrosion-resistant and gold-plated connectors for optimal signal clarity, effectively prolong the cable service life.
- USB3.0 FAST CHARGING & DATA SYNCING:Charging and data transmission two in one, the charging speed is up to 2A, and the data transmission speed is 10X faster than USB2.0 cable, also, this USB 3.0 extension cable backwards compatible with USB 2.0 and USB 1.1 standard devices.
- WORRY-FREE SERVICE: If you have any questions about our product, please feel free to contact with our reliable customer service, we will reply you within 24 hours. Package: USB 3.0 Extension Cable*1
Let me know the method you preferred using the “Was this page helpful?” question below.
Before you run, you may benefit from browsing our Windows Server how-to guides page.
Quick Recap
Bestseller No. 2
Rank #4
![CONMDEX Android Auto USB Cable [3ft, 2-Pack] 10Gbps, 3A Fast Charging | USB 3.1 Gen 2 | Stable Android Auto & CarPlay | Flexible & Durable | for iPhone 18 Pro Max Duo/17/16, iPad Pro, Galaxy S26](https://m.media-amazon.com/images/I/41vy0X7qsdL._SL160_.jpg)
CONMDEX Android Auto USB Cable [3ft, 2-Pack] 10Gbps, 3A Fast Charging | USB 3.1 Gen 2 | Stable Android Auto & CarPlay | Flexible & Durable | for iPhone 18 Pro Max Duo/17/16, iPad Pro, Galaxy S26
- [Reliable Car Connectivity & Android Auto] Engineered specifically to solve "falling short" connection issues in vehicles. This cable provides a stable, high-speed link for Android Auto and Apple CarPlay, ensuring consistent navigation and music streaming in models like the Ford Raptor and other modern consoles
- [True 10Gbps Ultra-Fast Data Sync] Eliminate data transfer bottlenecks with genuine USB 3.1 Gen 2 performance. Move 4K movies or entire photo libraries in seconds at 10Gbps—speeds significantly faster than standard USB 3.0 cables that often drop to 40Mbps
- [Built for Tidy Spaces & Durability] The 3ft length is the "perfect length" for car consoles and tidy desktop setups, eliminating excess cable clutter. Featuring an aluminum alloy case and premium nylon braiding, it is manufactured to prevent loose wires and fraying near the plugs
- [Versatile One-for-All Functionality] A single solution for your high-speed ecosystem. Seamlessly connects the latest iPhone 18 Pro Max Duo/17/16, Samsung Galaxy S26/S25/S24 Ultra, PS5/PS4 controllers, and external SSDs to USB-A ports
- [Charging & Compatibility Boundaries] Provides efficient 3A/18W fast charging for smartphones and tablets. Please note: This cable is optimized for mobile devices and is not intended for high-wattage laptops (65W+) or use cases requiring cables longer than 3 feet
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
