Access denied after OS Disk upgrade!?

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 .NETTake 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
>
>|||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.codecomments.com ***|||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 suspicious 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.
"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...
>|||http://sqljunkies.com/Forums/ShowPo...?PostID=701#701
http://www.microsoft.com/resources/...r />
gc20.mspx
Excerpt:
Hardware problems can also cause recovery failures. If files related to the
master database are damaged, you may see error messages similar to the
following:
. 2001-04-10 20:33:57.14 server. The system is older than SQL Server
7.0 RTM version and is not supported by this server. This error indicates
that SQL Server was unable to recognize this file as a valid master database
(.mdf) file. In this case the safest option is to replace the problematic
hardware and restore the master database.
Looks like you may need to restore or rebuils master db...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"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.codecomments.com ***|||I don't do attached files in newsgroups :-)
Look up the rebuild master utility in Books Online...it will trash anything
in the surrent master (assuming it is even readable).
Not sure if this is what you need, but since SQL Server isn't working at
all, do you have anything to lose? Copy out the the files for any other
databases you may have before running this...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"tjdarth" <tjohn1@.airmail.net> wrote in message
news:eh%23q1oujFHA.1412@.TK2MSFTNGP09.phx.gbl...
> Thanks Ken for your quick response. I presume that you mean rename the old
> Master.mdf file and copy a new master.mdf. Since I can't gain access to
> any feature of MSSQL. I am currently in the process of using the sqldiag
> command to see if anymore information may be obtained. It's feedback is
> also saying that it cannot connect, but it did write out a file
> SQLDIAG.txt summarizing the setup of my system. If you have ad to deal
> with this in the past maybe you could take some time with me to help
> understand and unravel this problem. I an sending a zip file of this text.
> Thanks for all your help , , ,Tom Johnson
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:u6l%23mmrjFHA.2156@.TK2MSFTNGP14.phx.gbl...
>
>|||Thanks Kevin for the insight. I took your suggestion and read the Rebuild
master utility information and ran the rebuild program. It returned a Failed
to rebuild (-1) type of error. I snooped a little further and found out that
there was a "Rebuild MSSQL Registry" application contained on the CD, so I
attempted to run this feature. This appeared to restore my registry, But I
had forgotten how I configured this application, so after the successful
completion of the registry restore, I got an Unable to signin
"Domain\userid".
Out of frustration, I completly removed MSSQL2000, and tried to reinstall
the application. This ran fine until the install process attempted to
'UpdateSystemPath' and gave the error msg: "ERROR - UNABLE TO UPDATE PATH
VARIABLE - RegDBGetKeyValueEX'. The errorLog file :"Attempting to initialize
Distributed Transaction Coordinator. server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b" So this is where I
am at this point.
Thanks again for all of your help. If you have any additional ideas, I would
welcome the help.
Thanks in advance . . . .Tom J.
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:Op14mwujFHA.1948@.TK2MSFTNGP12.phx.gbl...
>I don't do attached files in newsgroups :-)
> Look up the rebuild master utility in Books Online...it will trash
> anything in the surrent master (assuming it is even readable).
> Not sure if this is what you need, but since SQL Server isn't working at
> all, do you have anything to lose? Copy out the the files for any other
> databases you may have before running this...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "tjdarth" <tjohn1@.airmail.net> wrote in message
> news:eh%23q1oujFHA.1412@.TK2MSFTNGP09.phx.gbl...
>|||A DTC error should not prevent SQL from starting...does it, or are you
running?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"TomJ" <tjdarth@.verizon.net> wrote in message
news:O73hAa8jFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Thanks Kevin for the insight. I took your suggestion and read the Rebuild
> master utility information and ran the rebuild program. It returned a
> Failed to rebuild (-1) type of error. I snooped a little further and found
> out that there was a "Rebuild MSSQL Registry" application contained on the
> CD, so I attempted to run this feature. This appeared to restore my
> registry, But I had forgotten how I configured this application, so after
> the successful completion of the registry restore, I got an Unable to
> signin "Domain\userid".
> Out of frustration, I completly removed MSSQL2000, and tried to reinstall
> the application. This ran fine until the install process attempted to
> 'UpdateSystemPath' and gave the error msg: "ERROR - UNABLE TO UPDATE PATH
> VARIABLE - RegDBGetKeyValueEX'. The errorLog file :"Attempting to
> initialize Distributed Transaction Coordinator. server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b" So this is where
> I am at this point.
> Thanks again for all of your help. If you have any additional ideas, I
> would welcome the help.
> Thanks in advance . . . .Tom J.
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:Op14mwujFHA.1948@.TK2MSFTNGP12.phx.gbl...
>|||Thanks Kevin. I am in agreement that DTC should not prevent SQL from
starting. It appears from the ErrorLog that SQL had success in starting a
'single user mode session.' SQL then successfully started the masterDB,
model,msdb, pubs and Northwind' He successfully cleared the tempdb and
started it, and next stated that Recovery was complete. Next he started his
listening on the default urls and stated the he was ready for client
connections. This is the last statement in the ErrorLog: "SQL Server is
terminating due to 'stop' request from Service Control Manager."
The Setup log SQLSPT.log tells the story of Begin Action: UpdateSystemPath
"ERROR - UNABLE TO UPDATE PATH >> VARIABLE - RegDBGetKeyValueEX'- End
Action:UpdateSystemPath. It also indicates the following: "[Microsoft]&#
91;ODBC
Driver Manager] Data source name not found and no default driver specified"
for the MasterDB. This is the area that is giving me concern. I am not real
sure where to look next for resolution?
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23%23Sc4uRkFHA.3756@.TK2MSFTNGP15.phx.gbl...
>A DTC error should not prevent SQL from starting...does it, or are you
>running?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "TomJ" <tjdarth@.verizon.net> wrote in message
> news:O73hAa8jFHA.2852@.TK2MSFTNGP15.phx.gbl...
>sql