Monday, March 26, 2012

Poking a hole in Vista Firewall for sqlserver login

I've tried letting in 1433,1434 443,444 and I still can't get through. When I turn off the firewall, it works. What Am I missing?

I don't have Vista with SQL Server to test on (I guess luckily :) ), but this might help you?

http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx

|||

I read the article but it did not help. since I can connect without a firewall, i know it's port related. I'ved tried 1433 and 1434 with UDP as it suggests, but I still can not connect

|||Are you sure your SQL is using 1433 port? Check this in "SQL Server Configuration Manager". Then test with telnet to the SQL Service from the client, if telnet succeeds, we can go further. You can take a look at this post:
http://forums.asp.net/thread/1289341.aspx

No comments:

Post a Comment