Archived from groups: microsoft.public.windowsnt.domain,microsoft.public.sqlserver.connect (
More info?)
Yes, your server is not listening on tcp-ip, you need to run server network
utility and enable tcp-ip.
--
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Quest" <Quest@discussions.microsoft.com> wrote in message
news:38E9660E-B372-4BAA-A1B5-243D08EBC0CC@microsoft.com...
> Hi,
>
> I'm having the same problem running on my stand-alone laptop...I can't
> telnet into port 1433 either...
> running "netstat -an" with query analyzer and enterprise manager up and
> running don't show the port in
> use. I can only assume that they use the named pipes to connect to the DB
> engine. Ran the two commands
> suggested by RB: In the Server Network util, Named Pipes and TCP/IP are
> on.
> The default port for TCP/IP
> is 1433. For the Client Network util, in order, I have TCP/IP, then Named
> Pipes. Again the default port
> is 1433. Below is the error log and EventLog entries created from my most
> recent startup. I see no
> mention of it trying to listen on any TCP/IP port. There's also an error
> regarding:
> "TransactionDispenserInterface: Result Code = 0x8004d01b".
>
> I'm about to install Service Pack 3. If I get the same results, I'll move
> on
> to Service Pack 4. Would
> appreciate any feedback in resolving this or suggestions to as to where to
> look next.
>
> Cheers,
>
> Quest
> General Dynamics
>
>
>
> PS: Here's a copy of my latest SQL error log:
> ------------------------------------------------------------------------------------------------------------------------------
> 2005-09-01 04:24:27.62 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
> 2005-09-01 04:24:27.68 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2005-09-01 04:24:27.68 server All rights reserved.
> 2005-09-01 04:24:27.68 server Server Process ID is 1720.
> 2005-09-01 04:24:27.68 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2005-09-01 04:24:27.82 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2005-09-01 04:24:28.18 server SQL Server configured for thread mode
> processing.
> 2005-09-01 04:24:28.21 server Using dynamic lock allocation. [2500]
> Lock
> Blocks, [5000] Lock Owner Blocks.
> 2005-09-01 04:24:28.28 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2005-09-01 04:24:28.50 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2005-09-01 04:24:28.54 spid4 Starting up database 'master'.
> 2005-09-01 04:24:29.17 server Using 'SSNETLIB.DLL' version '8.0.194'.
> 2005-09-01 04:24:29.17 spid5 Starting up database 'model'.
> 2005-09-01 04:24:29.28 spid4 Server name is 'GEMSTONE'.
> 2005-09-01 04:24:29.28 spid8 Starting up database 'msdb'.
> 2005-09-01 04:24:29.28 spid9 Starting up database 'pubs'.
> 2005-09-01 04:24:29.28 spid10 Starting up database 'Northwind'.
> 2005-09-01 04:24:29.28 spid11 Starting up database 'LJ'.
> 2005-09-01 04:24:30.26 spid5 Clearing tempdb database.
> 2005-09-01 04:24:30.35 server SQL server listening on Shared Memory,
> Named Pipes.
> 2005-09-01 04:24:30.37 server SQL Server is ready for client
> connections
> 2005-09-01 04:24:34.28 spid5 Starting up database 'tempdb'.
> 2005-09-01 04:24:35.23 spid4 Recovery complete.
>
> -----------------------------------------------------------------------------------------------------------------------------
>
>
> Type Date Time Source Category Event User Computer
> Information 9/1/2005 4:24:35 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> 17052 :
> Recovery complete.
>
> Information 9/1/2005 4:24:31 AM H+BEDV AntiVir AntiVir 4096 SYSTEM
> GEMSTONE
> Information 9/1/2005 4:24:30 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> 17126 :
> SQL Server is ready for client connections
>
> Information 9/1/2005 4:24:30 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> 19013 :
> SQL server listening on Shared Memory, Named Pipes.
>
>
> Warning 9/1/2005 4:24:30 AM MSSQLSERVER (8) 19011 N/A GEMSTONE
> SuperSocket info: (SpnRegister) : Error 1355.
>
>
> Information 9/1/2005 4:24:29 AM MSSQLSERVER/MSDE None 5400 N/A GEMSTONE
> Information 9/1/2005 4:24:29 AM MSSQLSERVER/MSDE None 5400 N/A GEMSTONE
> Information 9/1/2005 4:24:29 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> 17834 :
> Using 'SSNETLIB.DLL' version '8.0.194'.
>
> Information 9/1/2005 4:24:28 AM MSSQLSERVER/MSDE None 5400 N/A GEMSTONE
> Information 9/1/2005 4:24:28 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> Information 9/1/2005 4:24:28 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> Information 9/1/2005 4:24:27 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> Information 9/1/2005 4:24:27 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> Information 9/1/2005 4:24:27 AM MSSQLSERVER (2) 17055 N/A GEMSTONE
> Information 9/1/2005 4:24:27 AM SecurityCenter None 1800 N/A GEMSTONE
>
>
>
>
>