[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

windows firewall blocking web service access

All,

I'm stumped.  I am running a web service on my local machine (win xp pro) that needs to access a SQL database on another server (win server 2003).  With Windows Firewall turned off on the database server, everything works fine.  But due to some security problems we have run into, our network guy would like to keep Windows Firewall turned on.

So, I can't for the life of me figure out what port and/or program I need to enable access to in the Windows Firewall exceptions list in order to allow a web service to connect.

Please help...

Nick
0
sharpnet
Asked:
sharpnet
1 Solution
 
oBdACommented:
SQL server runs on TCP port 1433; have a look here:
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/?kbid=287932
0
 
sharpnetAuthor Commented:
That was it.  Thanks!
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now