"TomJ" <tjdarth@verizon.net> wrote in message
news:%23V7UTUbjFHA.3972@TK2MSFTNGP10.phx.gbl...
>I recently had to upgrade my WIN-XP SP2 OS harddrive. I am now getting the
>following error message when I attemp to start MSSQL 2000 Developer edition
>through Enterprise Manager or Query Analyzer: "A connection could not be
>established to (LOCAL) Reason:SQL Server does not exist or access denied.
>ConnectionOpen (Connect()).. Please verify SQL Server is running and check
>your SQL Server registration properties ( by righ-clicking on the (LOCAL)
>node) and try again." When I take the suggested approach of right-clicking,
>I get the same message because he cannot connect!!?
>
> When I go to Admin Tools>Computer Management>Services and
> Applications>Services>MSSQLSERVER>Start, the service starts but then
> issues the mess:THE MSSQLSERVER SERVICE ON LOCAL COMPUTER STARTED AND
> STOPPED. sOME SERVICES STOP AUTOMATICALLY IF THEY HAVE NO WORK TO DO, FOR
> EXAMPLE, THE PERFORMANCE LOGS AND ALERTS SERVICE. And its back to square
> #1.
>
> Can someone help? Thanks in advance
>
> Tom Johnson A+, MCP, MCSD .NET
>
>
>

"Vikram Vamshi" <vikram.vamshi@online.eclipsys.com> wrote in message
news:OP$s$GkjFHA.1464@TK2MSFTNGP14.phx.gbl...
> Take a look at the ERRORLOG for more details. Normally the log is located
> in
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
> You can also try starting sql server in the console mode from the command
> prompt.
> If you have a default instance of sql installed in the default location,
> you should change directory to
> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
> and execute
> sqlservr -c
> the output messages to the console will give you a clue to what is going
> wrong.
> hth
> --
> Vikram Vamshi
> Database Engineer
> Eclipsys Corporation
> "TomJ" <tjdarth@verizon.net> wrote in message
> news:%23V7UTUbjFHA.3972@TK2MSFTNGP10.phx.gbl...
>>I recently had to upgrade my WIN-XP SP2 OS harddrive. I am now getting the
>>following error message when I attemp to start MSSQL 2000 Developer
>>edition through Enterprise Manager or Query Analyzer: "A connection could
>>not be established to (LOCAL) Reason:SQL Server does not exist or access
>>denied. ConnectionOpen (Connect()).. Please verify SQL Server is running
>>and check your SQL Server registration properties ( by righ-clicking on
>>the (LOCAL) node) and try again." When I take the suggested approach of
>>right-clicking, I get the same message because he cannot connect!!?
>>
>> When I go to Admin Tools>Computer Management>Services and
>> Applications>Services>MSSQLSERVER>Start, the service starts but then
>> issues the mess:THE MSSQLSERVER SERVICE ON LOCAL COMPUTER STARTED AND
>> STOPPED. sOME SERVICES STOP AUTOMATICALLY IF THEY HAVE NO WORK TO DO, FOR
>> EXAMPLE, THE PERFORMANCE LOGS AND ALERTS SERVICE. And its back to square
>> #1.
>>
>> Can someone help? Thanks in advance
>>
>> Tom Johnson A+, MCP, MCSD .NET
>>
>>
>>
>
>

"Thomas Johnson" <tjdarth@verizon.net> wrote in message
news:O48P$mmjFHA.1444@TK2MSFTNGP10.phx.gbl...
>
> Thank you Vikram Vamshi, for your quick response. I followed your
> suggestion by looking at the Log file which contains the following:
> 2005-07-21 21:51:27.42 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
> 2005-07-21 21:51:27.42 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-07-21 21:51:27.42 server All rights reserved.
> 2005-07-21 21:51:27.42 server Server Process ID is 5236.
> 2005-07-21 21:51:27.42 server Logging SQL Server messages in file
> 'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2005-07-21 21:51:27.51 server The system is older than SQL Server 7.0
> RTM version and is not supported by this server.
>
> I am suspcious of the last message about the system being older than SQL
> Server 70. RTM version and is not supported? Is this talking about my OS
> or is has something been corrupted for my MSSQL application?
>
> When I attempted your suggestion of trying to start from the command
> line, I get the identical same message.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***