Re: Access denied after OS Disk upgrade!?

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: Taking over Operations Master / DC roles
    ... > that with the exception of the Single Master Roles." ... my gameplan is to get the server updated and all info copied... ... Get the DNS setup and all my other odds and ends to the point that they are ... >> mapped install directory, and a time server. ...
    (microsoft.public.win2000.active_directory)
  • Re: Get Segmentation Fault when Building Sybase
    ... Doing ldd on the dataserver executable reveals that linux-gate is being used on 32 bit systems for system calls, but not on 64 bit, so any dodgy calls would be handled better on the 64 bit system. ... Building Adaptive Server 'LOCALHOST': ... Building master device... ... No external security mechanisms will be supported. ...
    (comp.databases.sybase)
  • Re: Disaster Recovery Plan
    ... preferable to restoring a master tape, ... Server and a HP tape drive. ... Attend a course taught by an expert instructor with years of in-the-field ...
    (Security-Basics)
  • Re: PCs not seeing each other
    ... MARK-X60S can ping MARK but MARK can not ping MARK-X60S ... Net config server ... Master browser name is: MARK-X60S ... There are 1 servers in domain ANY on transport ...
    (microsoft.public.windowsxp.network_web)
  • Re: Migrating Active Directory fom Win2000Srv to Win2003Srv standard
    ... Transfer the Schema Master Role ... type the name of the domain controller that will be ... How to view and transfer FSMO roles in Windows Server 2003 ...
    (microsoft.public.windows.server.migration)