Port Not Listening

Printable View

12-12-2008
Thomas R Grassi Jr

Port Not Listening

using portqry -n computer -e 1433 -p both

tcp 1433 NOT LISTENING

udp 1433 LISTENING or FILTERED

trying to connect to another sql server on my network and the firewalls
might be blocking this port.

Problem is on my workstation 1433 tcp is Listening

but onmy server windows 2003 1433 tcp is NOT LISTENING

So I stopped the windows firewall service but it still shows NOT LISTENING

what else blocks ports

Any ideas thanks

Tom
13-12-2008
Rahisuddin Shah

Re: Port Not Listening

If you have disable the personal firewall and there is not other firewall or
router that blocking the port 1433, then I would say check your SQL server.

--
Rahisuddin Shah
MCSE - MCSA - ITIL
"Thomas R Grassi Jr" <thomasgrassi@hotmail.com> wrote in message
news:OODf%23KBXJHA.5400@TK2MSFTNGP04.phx.gbl...
> using portqry -n computer -e 1433 -p both
>
> tcp 1433 NOT LISTENING
>
> udp 1433 LISTENING or FILTERED
>
> trying to connect to another sql server on my network and the firewalls
> might be blocking this port.
>
> Problem is on my workstation 1433 tcp is Listening
>
> but onmy server windows 2003 1433 tcp is NOT LISTENING
>
> So I stopped the windows firewall service but it still shows NOT LISTENING
>
> what else blocks ports
>
> Any ideas thanks
>
> Tom
>
>
>
13-12-2008
Alister

Re: Port Not Listening

On Dec 12, 4:33 am, "Thomas R Grassi Jr" <thomasgra...@hotmail.com>
wrote:
> using portqry -n computer -e 1433 -p both
>
> tcp 1433 NOT LISTENING
>
> udp 1433 LISTENING or FILTERED
>
> trying to connect to another sql server on my network and the firewalls
> might be blocking this port.
>
> Problem is on my workstation 1433 tcp is Listening
>
> but onmy server windows 2003 1433 tcp is NOT LISTENING
>
> So I stopped the windows firewall service but it still shows NOT LISTENING
>
> what else blocks ports
>
> Any ideas thanks
>
> Tom

Is the SQL a new install?

You don't say what version, but 2005 / 2008 by default disable TCP/IP
connections.

You have to specifically enable TCP/IP and Named Pipes by using
Microsoft SQL Server Configuration Manager.

Alister
13-12-2008
Thomas R Grassi Jr

Re: Port Not Listening

Alister

The version of SQL is Microsoft Desktop Engine 8.00.2050 SQL2000

I did use the network utility and configured both named pipes and tcp and
tcp using port 1433

but after i restarted sql server port 1433 is not opened

I have posted on the sql news group to see if MSDE2000 has any issues with
TCP

Any other ideas or thoughts

Thanks

Tom

"Alister" <alister.gcs@hotmail.co.uk> wrote in message
news:824a2afd-a2f2-4657-89d0-def77a1891ca@e1g2000pra.googlegroups.com...
> On Dec 12, 4:33 am, "Thomas R Grassi Jr" <thomasgra...@hotmail.com>
> wrote:
>> using portqry -n computer -e 1433 -p both
>>
>> tcp 1433 NOT LISTENING
>>
>> udp 1433 LISTENING or FILTERED
>>
>> trying to connect to another sql server on my network and the firewalls
>> might be blocking this port.
>>
>> Problem is on my workstation 1433 tcp is Listening
>>
>> but onmy server windows 2003 1433 tcp is NOT LISTENING
>>
>> So I stopped the windows firewall service but it still shows NOT
>> LISTENING
>>
>> what else blocks ports
>>
>> Any ideas thanks
>>
>> Tom
>
> Is the SQL a new install?
>
> You don't say what version, but 2005 / 2008 by default disable TCP/IP
> connections.
>
> You have to specifically enable TCP/IP and Named Pipes by using
> Microsoft SQL Server Configuration Manager.
>
> Alister
13-12-2008
Alister

Re: Port Not Listening

On Dec 13, 12:13 am, "Thomas R Grassi Jr" <thomasgra...@hotmail.com>
wrote:
> Alister
>
> The version of SQL is Microsoft Desktop Engine 8.00.2050 SQL2000
>
> I did use the network utility and configured both named pipes and tcp and
> tcp using port 1433
>
> but after i restarted sql server port 1433 is not opened
>
> I have posted on the sql news group to see if MSDE2000 has any issues with
> TCP
>
> Any other ideas or thoughts
>
> Thanks
>
> Tom
>
> "Alister" <alister....@hotmail.co.uk> wrote in message
>
> news:824a2afd-a2f2-4657-89d0-def77a1891ca@e1g2000pra.googlegroups.com...
>
> > On Dec 12, 4:33 am, "Thomas R Grassi Jr" <thomasgra...@hotmail.com>
> > wrote:
> >> using portqry -n computer -e 1433 -p both
>
> >> tcp 1433 NOT LISTENING
>
> >> udp 1433 LISTENING or FILTERED
>
> >> trying to connect to another sql server on my network and the firewalls
> >> might be blocking this port.
>
> >> Problem is on my workstation 1433 tcp is Listening
>
> >> but onmy server windows 2003 1433 tcp is NOT LISTENING
>
> >> So I stopped the windows firewall service but it still shows NOT
> >> LISTENING
>
> >> what else blocks ports
>
> >> Any ideas thanks
>
> >> Tom
>
> > Is the SQL a new install?
>
> > You don't say what version, but 2005 / 2008 by default disable TCP/IP
> > connections.
>
> > You have to specifically enable TCP/IP and Named Pipes by using
> > Microsoft SQL Server Configuration Manager.
>
> > Alister

Hi Tom,

Take a look at:

http://www.tech-archive.net/Archive/...4-04/0268.html

HTH

Alister