SQLEXPRESS connection to SAWS

Sometimes DvSum Gateway is unable to make connection to SQLEXPRESS. If you are sure you have provided the correct information and credentials and "Test Connection" still fails, please check the following settings on your computer.

mceclip0.png

 

Step 1: From Windows button, click on SQL Server Configuration Manager.

mceclip1.png

 

Step 2:  Click on Network Configuration in the Manager

mceclip2.png

 

Step 3: Double click on Protocols. Confirm if TCP/IP is enabled. 

If not enabled, right click and enable. (Don’t re-start service yet)

mceclip3.png

 

Step 4: Double click TCP/IP and in the dialog box, click on IP Address tab

 

Step 5: Scroll to bottom of page. Confirm that under IPAll, TCP Port is  set to 1433.

If not, add it and apply.

mceclip4.png

 

Step 6: Close and get back to Configuration Manager. Click on SQL Server Services on left side.

mceclip5.png

 

Step 7: Click on SQL Server (Running) and Click on Restart button in action bar.

mceclip6.png

Step 8: Once re-started, DvSum will connect to this database. Confirm the following in Manage Sources page.

mceclip7.png

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk