Re: Sql Express (Build 2047) XP SP2 not listening

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The log says "Server is listening on [ 'any' <ipv4> 1043]."
I've rechecked all of teh settings in teh Sql Configuration Utility
Protocols for SQLEXPRESS and Client Protocols. All of the settings
there are for port 1433.
I have restarted teh PC without any chnage.
Is there somewhere else to set this other that heh Sql Configuration
Utility?


On Sun, 24 Sep 2006 20:10:30 -0600, Sue Hoegemeier
<Sue_H@xxxxxxxxxxxxx> wrote:

Did you check the SQL Server logs from the startup to see if
the protocols are listed and what ports it's actually
listening on?
Did you enable remote connections for the protocols?
If it's a named instance - I think that's the default for
express - did you start the browser service (or restart
after changing connectivity settings)?
And also for the firewall, try creating an exception to
allow communication for sqlservr.exe and sqlbrowser.exe.

-Sue

On 24 Sep 2006 18:25:46 -0700, "Rlane"
<rmathuln@xxxxxxxxxxx> wrote:

I have installed Sql Server 2005 Express on a Windows XP PC running
SP2.
The Windows Firewall has ports 1433 and 1434 opened.
I ran the Sql Server Configuration Manager to set the Protocols for
SqlExpress and the Client Protocols to TCP and port 1433.
Restarted the PC.
Verified teh services are running.
Can connect on the same PC using Management Studio.
Cannot connect from other PCs though.
I run netstat -ano and I still cannot see the service listening on port
1433. I see the port 1434 there (SqlBrowser) but under UDP.

Am I missing a step(s) here?
.

Relevant Pages

  • Re: skills for mastering border security (firewalls,ips etc)
    ... First, understand the protocols. ... different programs using port 80 for everything but knowledge of the ... Learn all of the latest penetration testing techniques in InfoSec Institute's Ethical Hacking class. ... Totally hands-on course with evening Capture The Flag exercises, Certified Ethical Hacker and Certified Penetration Tester exams, taught by an expert with years of real pen testing experience. ...
    (Security-Basics)
  • Re: unsual entry using ipchains -nL
    ... The ports shown are HTTP, Telnet, ... Two of the three major IP protocols specify port numbers ...
    (comp.os.linux.security)
  • Re: Firewalls Supporting Protocols
    ... this drifted way off topic with nitpicking about protocols. ... > protocols such as FTP for rewriting of packet data such as the PORT ... PORT commands and responses to PASV commands in order to transiently open ...
    (comp.security.firewalls)
  • RE: Need More iptable Rules
    ... > Fedora will not take ipp or afp as protocols. ... TCP or UDP with that port. ... You'll want to find out whether afp uses TCP or UDP, ...
    (Fedora)
  • Re: jail getfsstat patches.
    ... > port it? ... I was looking at the original patch for 4.x (the one that is a kld ... It has a serious flaw in that if teh buf pointer is NULL it is supposed ... filesystems instead of the number in the jail. ...
    (freebsd-current)