Support
Accounts & Users
Backup
Blueprints
Lumen Edge Private Cloud
Cloud Application Manager
Administering Your Organization
Analytics
Automating Deployments
Billing
Cloud Optimization
Core Concepts
DR Readiness
Deploying Anywhere
FAQ
Getting Started
Integrating with Jenkins
Managed Services
Monitoring
Troubleshooting
Tutorials
Edge Computing Solutions
Control Portal
Dedicated Cloud Compute
General
Managed Services
Network
Release Notes
Servers
Service Tasks
Lumen Network Storage
Support
Accounts & Users
Backup
Blueprints
Lumen Edge Private Cloud
Cloud Application Manager
Administering Your Organization
Analytics
Automating Deployments
Billing
Cloud Optimization
Core Concepts
DR Readiness
Deploying Anywhere
FAQ
Getting Started
Integrating with Jenkins
Managed Services
Monitoring
Troubleshooting
Tutorials
Edge Computing Solutions
Control Portal
Dedicated Cloud Compute
General
Managed Services
Network
Release Notes
Servers
Service Tasks
Lumen Network Storage
Updated by Jake Malmad on Mar 20, 2015
Article Code: kb/876
OVERVIEW
A common troubleshooting step in database backed applications is making certain that communication is possible from the web or application server directly to the database. This article outlines a fast and easy way to verify connectivity from a Windows Server to a Microsoft SQL database.
Detailed Steps
-
Create a new text folder on the server by right click-> New -> "New Text Document". You may want to name it similar to the database to be tested, in this instance it is simply called "test.txt"
-
Change the file extension to .udl. You may need to enable "Show File Extensions" in the view pane
-
Rename the file extension to ".UDL"
-
Open the file, and you will be greated with a connection dialog.
- You can now enter the appropriate database hostname, credentials, and even choose the desired database from the drop down menu:
- Simply select "Test Connection" and you will be informed if the connection is successful or fails.