How do I configure SQL and SQL native client to accept ODBC connections?
Procedure Steps
- On the Database Server, locate and launch SQL Server Configuration Manager.
- Expand the following three headers to view the protocols:
- SQL Native Client 10.0 Configuration
- SQL Server Configuration
- SQL Native Client 10.0 Configuration
- Each protocol should be configured as follows:
- Shared Memory: Enabled
- Named Pipes: Enabled
- TCP/IP: Enabled
- VIA: Disabled
- If any changes were necessary, restart the SQL Server service.
Perform the following steps in the SQL Management Studio software:
- Log into SQL Management Studio.
- Right-click at the server name and select Properties.
- 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.
- Still on the Connection page, scroll down and find the Remote Server Connections. Confirm that Allow Remote Connections to this Server is selected.
- Select the Security section under Select a Page and make sure you are configured to use SQL Server and Windows Authentication mode.
- If any changes were made, restart the SQL Server service.
Applies To
OnGuard (All versions)