ODBC connection to SQL Server 2008 R2
11-Feb-1111 Leave a comment
On ODBC using SQL Native Client.
Many possible problems. But consider trying with Server Firewall off. If this is successful then consider the following changes on firewall which have worked for me.
Firewall settings on server are:
http://technet.microsoft.com/en-us/library/ms175043.aspx
![]() |
---|
To allow named pipes access through the firewall, you must also enable File and Printer Sharing through the firewall. |
—————
Also Firewall on server must add program SQLServer.exe which is at <program files><Microsoft SQL Server><MSSQL10_50.Instance Name\MSSQL\Binn\sqlservr.exe
————-
Prefer not using older ODBC SQL server, but if do then on client configuration dynamically chosen ports is relevant