Why do I have to enable File and Printer sharing to connect through the XP firewall?

Hello,

I have a client app that connects to a remote instance of SQL Server 2005
Express. The client uses the SQL Browser to locate available SQL instances.

The SQL instance has Shared Memory, Named Pipes, and TCP/IP turned on, and
TCP/IP is configured to use a static port (5721).

The firewall on the SQL machine has the following exceptions: 1434 UDP (SQL
Browser) and 5721 TCP (SQL Server).

I have no problems locating the SQL instance using Management Studio or with
the SQL Browser in my client. However, I cannot connect either with
Management Studio or my client unless I also turn on the "File and Printer
Sharing" exception in the firewall. The BOL says that File and Printer
Sharing is required if using Named Pipes through the firewall, but I don't
understand where Named Pipes are being used when I try to connect.

In my client (C# app) I'm using the SQLConnection class with a very vanilla
connection string; the only addition the the port number of the SQL
instance.

Is SQLConnection using Named Pipes behind the scenes? Can someone explain
what's going on here and suggest how I might get around having to turn File
and Printer Sharing on?

Thanks!

Keith

P.S. Everything works fine if the firewall is turned off.


.

Relevant Pages

  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
    ... I'd use cliconfg.exe on the client to verify that TCP/IP is selected higher than Named Pipes. ... Also, since you specify the port in your connection string, you shouldn't need the SQL Server browser service on the server. ... The SQL instance has Shared Memory, Named Pipes, and TCP/IP turned on, and TCP/IP is configured to use a static port. ...
    (microsoft.public.sqlserver.clients)
  • Re: Oracle 10g2 LIKE operator and case-insensitive issues
    ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • Re: Oracle 10g2 LIKE operator and case-insensitive issues
    ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
Loading