Posted by Danieltbt05 on 11/17/05 02:23

Hi, I have SP4. When i use netstat -an, there is no connection to my
client machine. Do you mean both server and client can set up port as
1234 ? I also attached my errorlog, maybe can look at it ? Btw if both
machine can ping by ip and name then it shouldn't be any connection
problem right ? Thanks.

2005-11-19 00:21:08.26 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.2 (Build 3790: )

2005-11-19 00:21:08.26 server Copyright (C) 1988-2000 Microsoft
Corporation.
2005-11-19 00:21:08.26 server All rights reserved.
2005-11-19 00:21:08.26 server Server Process ID is 1864.
2005-11-19 00:21:08.26 server Logging SQL Server messages in file
'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-11-19 00:21:08.29 server SQL Server is starting at priority
class 'normal'(1 CPU detected).
2005-11-19 00:21:08.40 server SQL Server configured for thread mode
processing.
2005-11-19 00:21:08.40 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2005-11-19 00:21:08.50 spid3 Starting up database 'master'.
2005-11-19 00:21:08.81 server Using 'SSNETLIB.DLL' version
'8.0.194'.
2005-11-19 00:21:08.81 spid5 Starting up database 'model'.
2005-11-19 00:21:08.87 spid3 Server name is 'BACKUP'.
2005-11-19 00:21:08.87 spid3 Skipping startup of clean database id
4
2005-11-19 00:21:08.87 spid3 Skipping startup of clean database id
5
2005-11-19 00:21:08.87 spid3 Skipping startup of clean database id
6
2005-11-19 00:21:08.87 spid3 Skipping startup of clean database id
7
2005-11-19 00:21:09.71 spid5 Clearing tempdb database.
2005-11-19 00:21:11.85 spid5 Starting up database 'tempdb'.
2005-11-19 00:21:12.03 spid3 Recovery complete.
2005-11-19 00:21:20.90 server SQL server listening on Shared Memory,
Named Pipes.
2005-11-19 00:21:20.90 server SQL Server is ready for client
connections
2005-11-19 00:22:47.93 logon Login succeeded for user 'Daniel'.
Connection: Non-Trusted.
2005-11-19 00:22:47.95 spid51 Starting up database 'Northwind'.
2005-11-19 00:22:48.82 spid51 Using 'xpstar.dll' version
'2000.80.194' to execute extended stored procedure 'xp_MSADEnabled'.
2005-11-19 00:22:49.09 spid51 Using 'xplog70.dll' version
'2000.80.194' to execute extended stored procedure 'xp_msver'.
2005-11-19 00:22:58.35 spid51 Starting up database 'msdb'.
2005-11-19 00:25:11.90 spid3 SQL Server is terminating due to
'stop' request from Service Control Manager.


Erland Sommarskog wrote:
> (Danieltbt05@gmail.com) writes:
> > Hi, I don;t think I have any firewall installed but how to verify that
> > no firewall is installed ?
>
> Windows 2003 comes with Windows Firewall by default doesn't it? If it's
> SP1, there is an applet in the Control Panel. If you don't have SP1, then
> you have right-click the network connection, click Properties for TCP/IP,
> and then look under the Advanced tab. (If memory serves.)
>
> > Also i have check that port 1433 is not there on the server and client.
> > Will SQL server only connect to this port or any other port number ?
> > I've read that SQL will dynamically connect from port 1024 onwards, is
> > it true ? If alias is not connected with ip address , port number and
> > even name , then how does it connect to the server ?
>
> A default instance of SQL Server listens to port 1433 by default. Non-
> default instances typically uses other ports. When a client connects to
> a non-default instance it first interrogates on UDP port 1434 to get the
> actual port number. If that service is not available, for instance because
> of a firewall, you can set up alias with the actual portnumber. I think you
> also can specify the port number when you connect as SERVER,1234.
>
> Finally, you did install service pack3 or 4 for SQL 2000, didn't you?
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]