How do I configure SQL and SQL native client to accept ODBC connections?

How do I configure SQL and SQL native client to accept ODBC connections?

Procedure Steps

  1. On the Database Server, locate and launch SQL Server Configuration Manager.
  2. Expand the following three headers to view the protocols:
    • SQL Native Client 10.0 Configuration
    • SQL Server Configuration
    • SQL Native Client 10.0 Configuration
  3. Each protocol should be configured as follows:
    • Shared Memory: Enabled
    • Named Pipes: Enabled
    • TCP/IP: Enabled
    • VIA: Disabled
  4. If any changes were necessary, restart the SQL Server service.

Perform the following steps in the SQL Management Studio software:
  1. Log into SQL Management Studio.
  2. Right-click at the server name and select Properties.
  3. Locate the Connections page. At the top of the page you will see the Connections header, and the value for maximum number of concurrent connections should be set to 0.
  4. Still on the Connection page, scroll down and find the Remote Server Connections. Confirm that Allow Remote Connections to this Server is selected.
  5. Select the Security section under Select a Page and make sure you are configured to use SQL Server and Windows Authentication mode.
  6. If any changes were made, restart the SQL Server service.
 

Applies To

OnGuard (All versions)

Additional Information