Re: MSDE 2000 SP3a on a Windows 2003 server

From: Kaz (ganthi753_at_yahoo.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 15:06:50 -0800

Thanks Jim, I got pointed in the right direction to find
some information on Microsoft's knoledge base.

Apperently my ports are setup correctly, but MSDE server
is unable to bind the selected port even though it is not
in use by another application. I receive the following
information on my MSDE server log file:

2004-02-20 15:35:12.26 server SuperSocket Info: Bind
failed on TCP port 1433.
2004-02-20 15:35:12.26 server SQL server listening on
10.22.4.52: 1433.
2004-02-20 15:35:12.26 server SQL server listening on
127.0.0.1: 1433.
2004-02-20 15:35:12.37 server SQL server listening on
TCP, Shared Memory.
2004-02-20 15:35:12.37 server SQL Server is ready for
client connections

If the Bind wasn't failing, everything would be working
fine I think.

Any ideas why the Bind would be failing?

>-----Original Message-----
>Are you sure you installed MSDE 2000 SP3a? Versions
previous to SP3 will
>install on 2003 but you will get a warning in the event
log that the
>Ynetwork ports to the application are blocked with a
directive to upgrade.
>Tou could do a netstat -a to show what ports the server
is listening on.
>Also look in the log for SQL Server and see whether it is
loading any
>network protocols when starting up.
>
>Jim
>
>"Kaz" <ganthi753@yahoo.com> wrote in message
>news:1394501c3f7b8$cd4bb5c0$a001280a@phx.gbl...
>> I have installed MSDE 2000 SP3a on both Standard and
>> Enterprise Windows Server 2003 with the same problem. I
>> can login to OSQL or Enterprise Manager from the local
>> machine with any valid account, but when I attempt to
>> login with the same accounts from another computer in
the
>> network I am unable to connect. I recieve the following
>> error:
>>
>> SQL Server does not exist or access is denied.
>> ConnectionOpen(Connect())..
>>
>> If I install MSDE the same way on Windows 2000 or XP I
>> have no connection problems.
>
>
>.
>

Relevant Pages

  • Re: Whats a decent modem/router for tech savy user?
    ... It is not possible to route or deny traffic to specific ports based on the source IP address. ... But it wont route back inside the LAN - needs internal DNS server spoofing. ... Normally, this option should be Enabled, so that an Internet connection will be made automatically, whenever Internet-bound traffic is detected. ... Specifying a Default DMZ Server allows you to set up a computer or server that is available to anyone on the Internet for services that you haven't defined. ...
    (uk.telecom.broadband)
  • Re: Cannot connect to RWW from home PC
    ... That would be the address you need a DNS record for. ... You say "And in the router you need to forward to your external nic IP" ... Still can't telnet to any of your ports at your public ip address. ... Heres' the info for our server: ...
    (microsoft.public.windows.server.sbs)
  • Re: Netopia 3347NWG with Remote Desktop and Remote Web Workplace
    ... Glad you're back in business Greg! ... Ports Closed ... Despite this, Remote Web Workplace DOES WORK now, and Connect to Server ... Exchange BPA updates), ...
    (microsoft.public.windows.server.sbs)
  • Solution -> Re: SSH tunnel question.
    ... change IPS and ports around but that is not a big deal. ... telnet/ftp/rsh open on a server including on the Internet facing ports! ... I will go from the corp desktop to a hop ... through the firewall to the hop ...
    (SSH)
  • Re: Exch2003 front-end questions
    ... all the supported protocol ports must be open on the inner ... communication between the front-end server and the back-end servers. ... lists the ports required for the intranet firewall. ...
    (microsoft.public.isa)