SQL Server - Testing database connections
One of the past challenges with troubleshooting SQL database connections has been with having a tool to connect to the SQL database - determining if the port is available on the target server and the service is running.
Starting in Windows 10, this has been simplified by a built-in DB connection manager. You can easily test a connection to the database using a standard Microsoft connector:
- Create a text file on your desktop and change the extension to .UDL (give it a name like “testdb.UDL”)
- Confirm with Windows you wish to change the file extension
- Double-Click the files (or right click and select open)
- Windows will spawn the system Data Link Properties dialog.
- From this dialog, you can enter a server and login credentials and use the “Test Connection” button to confirm you were able to connect to the database.
NOTE: Be aware that the source machine you use for the test is a factor. For example, your computer may not be able to access the database due to restrictions on the network or SQL server. Where possible you should test the connection from a computer you would expect to have access, like the OpenData EE application server.
Related Articles
SQL Server - Changing Database Location / Server
When changing database location / server you will need to update the following files and tables. In the Opendata file structure: database.properties - contains database connection info - Located: C:\Program ...SQL Server - Database Growth Estimation Excel
The attached file is a database growth estimation tool in a Microsoft Excel workbook.SQL Server - Adding Templates to Bulk Upload Menu
The steps to add a Device Template to the bulk upload menu on OpendataEE are: 1) Move the completed template into the appropriate directory. The default root device template directory is: C:\Program ...SQL Server - Fixing Remote Edit Button
If the Remote Edit button sends you to an error page or the wrong Device Gateway here is how to fix it. Run the following query to generate a complete picture of the tables used to generate the remote edit URLs. select d.name,d.device_id, ...SQL Server - Manual Device Deletion
If you need to remove a device from the dashboard and it is not possible to use the Delete button on the Administration > Devices page, you can do it through SQL Management Studio. Marking a Device as Deleted In Management Studio run the following ...