Re: Server not listening on 1433

Run the SQL "Server Network utility" (svrnetcn) and make sure that TCP/IP is
in the Enables list of protocols.

Also can you post your errorlog, that would give us some more information
....

hth
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Greg New" <GregNew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BA3A73A8-87AF-4830-B752-F8F46615DC5E@xxxxxxxxxxxxxxxx
> Hi,
>
> I found this in the log which makes me think that it's just not listening
> on
> TCP
> "SQL server listening on Shared Memory, Named Pipes."
> Any ideas?
>
> Thanks for your help.
> Cheers,
> Greg
>
> "Shri.DBA" wrote:
>
>> Hi Greg,
>>
>> As you doubt, sql server may be listening in a different port. Check SQL
>> Server error log. SQL Server records in SQL Server error log, to which
>> port
>> it is listening to...
>>
>> Regards
>> Shri.DBA
>>
>> "Greg New" <Greg New@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:EBEC2E41-F72E-43CD-BCD2-28B8E7284128@xxxxxxxxxxxxxxxx
>> > Hi All,
>> >
>> > Very strange problem here! Installed SQL 2000 on my Windows Server 2003
>> with
>> > SP1. All went well. Got my DB working and clients connecting fine.
>> >
>> > Went to connect a box in the DMZ via ODBC using TCP/IP on 1433 and it
>> failed
>> > to connect. Tried another box on the LAN and that wouldn't connect. Had
>> > a
>> > look on the server and it seems that the server isn't listening on 1433
>> > netstat -a
>> >
>> > I've checked the Network properties, client network and server network
>> > in
>> > SQL and all is set as I would expect it. Nothing else is listening on
>> those
>> > ports. I can connect fine by named pipes but the DB vendor would prefer
>> > me
>> to
>> > use TCP/IP.
>> >
>> > Has anyone got any ideas? The SQL is SP3. It's a Compaq server that was
>> > rebuilt from scratch only a few days ago.
>> >
>> > If a client connects using dynamic ports what would i see when i do a
>> > netstat -a or -b or -an ?
>> >
>> > Many thanks,
>> >
>> > Greg
>>
>>
>>


.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... listening on UDP 1434 using netstat -abn, ... And i double checked the connection string, and i did have it the right ... But I have another 2000 server that I can connect to fine, ... I am trying to connect from an XP SP2 machine remotely to a SQL Express ...
    (microsoft.public.sqlserver.connect)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)