Win2003 firewall and mssql

Hi,
Yesterday i've activated the SP1 firewall on a win2003 server.
On this server i've Mysql and MSSQL running.
I've activated all the ports needed
Right now everything works except MSSQL
On the firewall i've opened port 1433 tcp and udp and the port 1434
udp.


The error i get from some scripts when the firewall is on is:


Microsoft OLE DB Provider for SQL Server error '80004005'


[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.


Obviously on the server network utility I've checked that the actived
tcp/ip port is the 1433.


How can I resolve this issue?


Thanks.

Roger
Sun Nov 06 09:39:51 CST 2005


"FOX" <fox80129@gmail.com> wrote in message
news:1131270196.782510.126300@g49g2000cwa.googlegroups.com...
> Hi,
> Yesterday i've activated the SP1 firewall on a win2003 server.
> On this server i've Mysql and MSSQL running.
> I've activated all the ports needed

apparently not
how is it that you did this, as it may be done in a few
different way in the W2k3 WF

> Right now everything works except MSSQL
> On the firewall i've opened port 1433 tcp and udp and the port 1434
> udp.
>
>
> The error i get from some scripts when the firewall is on is:
>
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
>
>
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
>

and we can assume that if you only just shut off the firewall
then all remote access to MSSQL works as expected ??

>
> Obviously on the server network utility I've checked that the actived
> tcp/ip port is the 1433.
>
>
> How can I resolve this issue?
>
>
> Thanks.
>

FOX
Mon Nov 07 11:30:05 CST 2005

I went to : Control Panel --> Windows Firewall --> Exceptions --> Add
Port --> and i added the ports needed.
Obviously when the firewall is shut down MSSQL works fine.


Thanks
Manuel

Roger
Mon Nov 07 14:50:45 CST 2005

Try adding the application
Adding ports opens only those ports, if others are opened
after the initial they are not covered, but are with an app
exception.
You would be surprised how often the obvious is not
hence the question as it was not stated.

"FOX" <fox80129@gmail.com> wrote in message
news:1131384605.417638.135870@g14g2000cwa.googlegroups.com...
>I went to : Control Panel --> Windows Firewall --> Exceptions --> Add
> Port --> and i added the ports needed.
> Obviously when the firewall is shut down MSSQL works fine.
>
>
> Thanks
> Manuel
>

FOX
Mon Nov 07 15:22:06 CST 2005

Unfortunately i added the application (SQL Service Manager) but still
doesn't work.

Thanks
Manuel

Roger
Wed Nov 09 13:20:29 CST 2005

What you added is the little taskbar applet that lets you see if the
server is running and start/pause/stop it.

"FOX" <fox80129@gmail.com> wrote in message
news:1131398526.953113.156280@f14g2000cwb.googlegroups.com...
> Unfortunately i added the application (SQL Service Manager) but still
> doesn't work.
>
> Thanks
> Manuel
>

alorent_z
Thu Nov 17 07:08:58 CST 2005

Not sure if related to this kind of issue, but this may help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328476