Question
How does the SQL Server instance configuration affect ODBC connectivity?
Asked by: USER1286
72 Viewed
72 Answers
Responsive Ad After Question
Answer (72)
The SQL Server instance configuration determines whether the instance is configured to allow remote connections. In SQL Server Configuration Manager, you need to ensure that TCP/IP is enabled and listening on the appropriate port (usually 1433). Additionally, the SQL Server instance must be configured to allow connections from the client's IP address or subnet.