Create SQL Server Native Client Connection

To create a SQL Server Native Client connection, do the procedure in this topic.

How to Start

  1. Open the ODBC Data Source Administrator

Procedure

  1. On the ODBC Data Source Administrator screen, click Add.
  2. On the Create New Data Source screen, select SQL Server Native Client 11.0.
  3. Click Finish.
  4. On the Create a New data Source to SQL Server screen, in the Name field, enter a unique name for your ODBC connection.
  5. In the Description field, enter the description about the connection we are going to establish.
  6. In the Server field, enter the SQL database server name.
  7. Click Next.
  8. In the Login ID field, enter the user name to connect with the SQL Server.
  9. In the Password field, enter the password for authentication to SQL Server.
  10. Click Next.
  11. Click Finish.
  12. On the ODBC Microsoft SQL Server Setup screen, click Test Data Source.
  13. When your test is completed Successfully. click OK.