How to test a SQL Server connection outside of Design Manager

Modified on: 2017-04-27 14:47:12 -0400


To test a connection to an SQL Server Database to trouble shoot problems you can create a connection to the database through windows control panel using Windows Authentication.  The instructions shown here are for Windows XP…

  1. Go to Control Panel, Administrative Tools
  2. Click on Database Sources
  3. Click On Add
  4. Click on SQL Server Native Client 10.0…If you do not see this on the list, then you do not have the Native Client Setup on your computer.  The SQL Native Client 10 can be downloaded from Microsoft.  Provider names are as follows SQLNCLI10.1 for SQL 2008/2008 R2, SQLNCLI11 for SQL 2012.  Note that the 2012 native client does not operate on Windows XP. 
  5. Click Finish
  6. In the name type Test DM Connection
  7. You can leave the Description blank.
  8. Use the dropdown list to choose the Server and SQL Instance that is hosting your database.
  9. Click Next
  10. Make sure Integrated Windows Authentication is selected (this is what DM uses, DM does not use SQL Server Authentication), SPN can be left blank.
  11. Click Next
  12. Click on Change the default database.
  13. Use the dropdown list to select the DM database (this is usually named DMP70 but could be the same as your DP serial number such as DP123).
  14. Click Next (leave the rest of the defaults)
  15. Click Next (leave all defaults on this window)
  16. Click Test Data Source, if the test completes with no issues, you should be able to run using DM.  You can click OK to save the configuration for future test.




Did you find this helpful? Yes No

Can you please tell us how we can improve this article?