"hon123456" <peterhon321@yahoo.com.hk> wrote in message
news:1129889832.370296.171400@f14g2000cwb.googlegroups.com...
> Dear all,
>
> I am writing ASP to connect to SQL server. In the connection
> string,when I write the database server as "(Local)" or ".", it will
> connected sucessfully. But When I used "127.0.0.1" or "localhost", it
> complains with the message "SQL server does not exist or access
> denied", or sometimes the browser return blank screen without the
> complain message "SQL server does not exist or access denied".
>
> I already have tcp/ip in client network utility with port 1433.
>
> I can ping 127.0.0.1 and localhost successfully.
>
> Is there possible that the ASP is connecting to wrong port number.
>
> Please help. The following is the SQL Server log.
>
>
>
>
>
> 2005-10-21 11:58:08.07 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
>
> 2005-10-21 11:58:08.23 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-10-21 11:58:08.23 server All rights reserved.
> 2005-10-21 11:58:08.23 server Server Process ID is 1632.
> 2005-10-21 11:58:08.23 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
> 2005-10-21 11:58:08.35 server SQL Server is starting at priority
> class 'normal'(1 CPU detected).
> 2005-10-21 11:58:09.98 server SQL Server configured for thread mode
> processing.
> 2005-10-21 11:58:10.04 server Using dynamic lock allocation. [500]
> Lock Blocks, [1000] Lock Owner Blocks.
> 2005-10-21 11:58:10.46 spid3 Starting up database 'master'.
> 2005-10-21 11:58:12.40 server Using 'SSNETLIB.DLL' version
> '8.0.766'.
> 2005-10-21 11:58:12.40 spid5 Starting up database 'model'.
> 2005-10-21 11:58:12.45 spid3 Server name is 'MIT003'.
> 2005-10-21 11:58:12.45 spid3 Skipping startup of clean database id
> 4
> 2005-10-21 11:58:12.48 spid3 Skipping startup of clean database id
> 5
> 2005-10-21 11:58:12.48 spid3 Skipping startup of clean database id
> 6
> 2005-10-21 11:58:12.89 spid5 Clearing tempdb database.
> 2005-10-21 11:58:12.90 server SQL server listening on Shared Memory.
> 2005-10-21 11:58:12.90 server SQL Server is ready for client
> connections
> 2005-10-21 11:58:13.48 spid5 Starting up database 'tempdb'.
> 2005-10-21 11:58:13.67 spid3 Recovery complete.
> 2005-10-21 11:58:13.67 spid3 SQL global counter collection task is
> created.
> 2005-10-21 12:00:36.05 spid51 Starting up database 'eSPRA'.
> 2005-10-21 12:00:36.24 spid52 Starting up database 'EngineWeb'.
> 2005-10-21 15:31:11.75 spid51 Using 'xpstar.dll' version
> '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
> 2005-10-21 15:31:20.41 spid51 Starting up database 'msdb'.
>

"hon123456" <peterhon321@yahoo.com.hk> wrote in message
news:1129943721.607825.167250@z14g2000cwz.googlegroups.com...
> Thanks Brad.
>
> Can u tell me where can I find/start the server network utility. Can I
> start the server network utility in Window? Can I start the server
> network utility by command?
>
> Because I cannot find the server network utility Under the MS SQL
> Server Group.
>
> Thanks.
>