Re: Access denied after OS Disk upgrade!?

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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Op14mwujFHA.1948@xxxxxxxxxxxxxxxxxxxxxxx
>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@xxxxxxxxxxx> wrote in message
> news:eh%23q1oujFHA.1412@xxxxxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:u6l%23mmrjFHA.2156@xxxxxxxxxxxxxxxxxxxxxxx
>>> http://sqljunkies.com/Forums/ShowPost.aspx?PostID=701#701
>>>
>>> http://www.microsoft.com/resources/documentation/msa/idc/all/solution/en-us/oag/oagc20.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@xxxxxxxxxxx> wrote in message
>>> news:O48P$mmjFHA.1444@xxxxxxxxxxxxxxxxxxxxxxx
>>>>
>>>> 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 ***
>>>
>>>
>>
>>
>>
>
>


.

Relevant Pages

  • Re: Error 823 with msdb
    ... There is a way to rebuild msdb from scratch. ... Try this on a test server before doing this on a production server ... Start SQL Server from the command prompt recover just the master ...
    (microsoft.public.sqlserver.server)
  • Re: Sortierung der Datenbank MASTER
    ... SQL Server 2000: ... How to rebuild the master database (Rebuild Master utility) ...
    (microsoft.public.de.sqlserver)
  • Re: rebuild master again...
    ... Rebuildm.exe will rebuild all the system databases (Master, Model, MSDB). ... restore the master database follwed with MSDB databse restore, ...
    (microsoft.public.sqlserver.server)
  • Re: Error 823 with msdb
    ... A rebuild of Master will recreate the structure and base data, ... -- "Russell Stevens" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Server Collation
    ... >collation settings for SQL Server. ... >Before you run the Rebuild master utility, ... >Rebuilding the master database removes all database ...
    (microsoft.public.sqlserver.programming)
Loading