firewalls & SQL Server connection

  • Thread starter Thread starter Stephen Russell
  • Start date Start date
S

Stephen Russell

I have a client that just bought new equipment. SP2 is installed as well as
Norton Firewall.

What are the steps I need to do to open up SQL server so they can access the
server now?

How do I find the port that SQL is running on is probably another Q.

TIA

__Stephen
 
I forgot another method to facilitate debugging will be netstat -a -n.
This will list all applications that using ports. If you do a
netstat -a - n >netstatoutput.txt
netstatoutput.txt

this file should now open in notepad. Search for 1433 and 1434. If they
are listed then that will mean that the services are enabled and
listening. Also checking whatever firewalls are enabled. You should
probably make sure that the client does not have both SP2 ICF enabled
AND norton Firewall. If they do this may make troubleshooting very
difficult. both should have troubleshooting logs for troubleshooting
dropped connections.
 
Back
Top