Re: Access denied after OS Disk upgrade!?

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: SQL 2000 server TCP bind problem
    ... If so then some other service grabbed port 1433 before SQL ... Server did. ... You can restore a backup of the master database if needed. ... There is also a utility to rebuild the master database ...
    (microsoft.public.sqlserver.connect)
  • RE: Disconnected Database Solution.
    ... > while disconnected from the main database (SQL Server ... > directional upload/download new information since last ... Are there any such features available in SQL ... > Server level I can synchronize with the master database ...
    (microsoft.public.sqlserver.programming)
  • RE: Disconnected Databases on Laptops
    ... in case you will be targeting smaller compact devices like pocket PC try ... > while disconnected from the main database (SQL Server ... > Server level I can synchronize with the master database ...
    (microsoft.public.sqlserver.ce)
  • Re: login failed for user username
    ... Since the Master database holds the login information, ... Master database, if not you have move the logins atleast to new server. ... > In the SQL Server log there is a message Login failed for user 'username'. ...
    (microsoft.public.sqlserver.server)