How does the SQL Server instance configuration affect ODBC connectivity?

Responsive Ad Header

Question

Grade: Education Subject: Support
How does the SQL Server instance configuration affect ODBC connectivity?
Asked by:
72 Viewed 72 Answers
Responsive Ad After Question

Answer (72)

Best Answer
(363)
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.