TABLE OF CONTENTS

• Troubleshooting Database Connectivity Issues
• Check Network Connectivity
• Check Database Connectivity
• Further Support

Troubleshooting Database Connectivity Issues

ManagementStudio depends on a SQL database to store and retrieve all collected data, including application usage and deployment schedules. Connectivity problems can cause degraded performance or prevent access to ManagementStudio.

If you encounter issues connecting to the database, follow the steps below to identify and resolve common causes.

Check Network Connectivity

Use the PowerShell Test-NetConnection cmdlet to verify network connectivity between the servers involved in your ManagementStudio deployment.

Test connectivity in these scenarios:

• From your local machine to the ManagementStudio IIS server
• From your local machine to the ManagementStudio SQL server
• From the ManagementStudio IIS server to the ManagementStudio SQL server

To run the diagnostic:

1. Open Windows PowerShell:
   • Click Start, type PowerShell, and select Windows PowerShell.
2. Enter the following command, replacing [servername] and [Port]with the appropriate values:

   Test-NetConnection -ComputerName [servername] -Port [Port]
   

   Example:

   Test-NetConnection -ComputerName managementstudio.local -Port 1433
   

If the test fails, a warning is displayed. Common causes include network infrastructure issues, such as firewall restrictions or DNS misconfiguration.

Check Database Connectivity

To test the connection between the ManagementStudio IIS server and the SQL server:

1. On the ManagementStudio IIS host, create a file named SQLTest.udl.
2. Double-click the file to open the Data Link Properties window.
3. Enter the following details:
   • SQL Server name and instance
   • ManagementStudio service account and password
   • Select the ManagementStudio database from the drop-down menu
4. Click the Test Connection button.

If the test fails, review the username and password. Incorrect credentials commonly cause database connection failures.

Further Support

If you need additional assistance, visit ManagementStudio Service Desk to search the knowledge base or submit a support ticket.