CODEWITHSUNDEEP
sqlsql-server-2012
Jason
Jason

Reputation: 367

sql server firewall ports

Having trouble connecting to SQL Server 2012 through my router firewall. I opened ports 2382 for the SQL Browser and 1433 for the SQL Server. I can connect from the server to itself with the LAN IP address but not using the external router IP. I got some good info from this question.

Opening ports for server instances

I'm using the instance port they mentioned and it works also, but only if I connect from the server to itself using...

Data Source=192.168.1.2,49867;Network Library=DBMSSOCN;Initial Catalog=Characters;

I also can't connect from another PC on my LAN. Which seems odd. I have disabled the windows firewall on the server just in case.

Thanks for any info!

Upvotes: 1

Views: 3730

Answers (1)

Sebastian Meine
Sebastian Meine

Reputation: 11783

Check if "Allow remote connections to this server" is enabled under "Server Properties -> Connections" in SSMS

Upvotes: 1

Related Questions