Friday, June 17, 2011

How to correct connection refused exception with port 1433 on MSSQL server

On the SQL Server network configuration manager, select protocols for SQL…. On the TCP/IP option, click and enable it if it is disabled. Note that Listen ALL option is disabled.

image

On the IP Address tab,

image

select the ip where you want to listen to port 1433 and make sure its enabled, with the TCP port configured to 1433 as shown in the image. That’s it.

0 comments:

Post a Comment