Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Stoad strehngthend
Yak Posting Veteran
54 Posts |
 Posted - 2008-08-19 : 06:49:44
|
Stand-alone (home) machine.Ping 127.0.0.1 works Ok.Of course, Tcp/ip is enabled, in Server Network Utility.But it listens only over Shared memory. From its ERRORLOG:2008-08-19 13:07:46.92 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)2008-08-19 13:07:46.92 server Copyright (C) 1988-2000 Microsoft Corporation.2008-08-19 13:07:46.92 server All rights reserved.2008-08-19 13:07:46.92 server Server Process ID is 956.2008-08-19 13:07:46.92 server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.2008-08-19 13:07:46.96 server SQL Server is starting at priority class 'normal'(1 CPU detected).2008-08-19 13:07:46.99 server SQL Server configured for thread mode processing.2008-08-19 13:07:46.99 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.2008-08-19 13:07:47.01 server Attempting to initialize Distributed Transaction Coordinator.2008-08-19 13:07:47.03 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b2008-08-19 13:07:47.04 spid3 Starting up database 'master'.2008-08-19 13:07:47.18 server Using 'SSNETLIB.DLL' version '8.0.194'.2008-08-19 13:07:47.18 spid5 Starting up database 'model'.2008-08-19 13:07:47.32 spid3 Server name is 'HOME'.2008-08-19 13:07:47.32 spid8 Starting up database 'msdb'.2008-08-19 13:07:47.37 server SQL server listening on Shared Memory.2008-08-19 13:07:47.37 server SQL Server is ready for client connections Never have encountered such a trouble with v.7.0.But for some reason I need it listening, locally, namely over tcp/ip. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Stoad strehngthend
Yak Posting Veteran
54 Posts |
Posted - 2008-08-19 : 12:54:54
|
| No, khtan. Not that.I looked into Win_XP Event Viewer.It turned out that tcp/ip and udp ports of SS are disabled (by SS itself, I think :) or by OS?) on purpose,for the sake of my safety, lol. Event Id = 5400. It recommends to download a security patch for SS or service packs. But right now I can't download anything more in size than ~500KB. Maybe there is some key in registryand to turn it on will be enough. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-19 : 23:25:28
|
| What do you mean 'tcp/ip and udp ports of SS are disabled'? Are they blocked in firewall on the server? |
|
|
|
Stoad strehngthend
Yak Posting Veteran
54 Posts |
Posted - 2008-08-20 : 11:48:22
|
| it's a notification from Application Events. It reads: because of recent vulnerability of ms sql server(they mean Slammer etc) these ports are disabled. Download the latest service pack. Pity it's in Russian.Firewall has nothing to do with it. WinXP Professional SP2. I don't know whose its notification. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-20 : 23:11:09
|
| You should apply sp4 first. |
|
|
|
|
|
|
|
|
How to force Sql Server 2000 to listen over TCP/IP