Articles in this section

See more

Testing connectivity to SQL server

  • Updated

An ODBC System data source stores information about how to connect to a data provider. You can use the ODBC Administrator to test connectivity to SQL Server. 

Follow these steps to do so:

  1. Open your ODBC Data Source Administrator (Control Panel, ODBC data sources).
  2. Go to the System DSN tab and click Add.
  3. On the wizard, select SQL Server driver and click Finish.
  4. Enter a Name for the data source name, Description and SQL Server to which you want to connect.
  5. Select the option 'With SQL Server authentication using a login ID and password entered by the user'.
  6. Click on Client Configuration. Select TCP/IP network libraries. 
  7. Dynamically determine port and select Server Alias and Server Name. Try using TCP/IP. Click Next.
  8. Select the default database and click Next.
  9. Click Finish. A dialog appears displaying some settings.
  10. Click Test Data Source. If it displays 'Tests Completed Successfully!', your machine is able to connect to the SQL Server.

Related articles