SQL 7.0 master.mdf - file not accessible

[bhargava]

Hi all,

my sql server is not starting up on WinNT 4.0 SP4. I installed it on a brand new Server (DB server) just couple of days back. It ran fine for a few days and one fine morning it went berserk. When I checked in the Event Viewer, I found a following failure entry -

'17113 :
initconfig: Error 5(Access is denied.) opening 'D:\MSSQL\data\master.mdf' for configuration information.'

My last option I know is to reinstall the same, but in the process I will have to re-migrate my old data onto the new server. Also let me know that if I have to opt for this option, then will unistallation go smoothly, in absence of access to master.mdf. (What are my available options in all cases?).

Pls. help as to how do I solve this problem

Regards

Amit Bhargava

 

[Bernadette]

Hi There

This is taken from MS Knowledge Base. It sounds like it is exactly your problem

PRB: Cannot Reinstall SQL Server After Deleting Files Manually

------------------------------------------------------------
The information in this article applies to:

Microsoft SQL Server version 6.5

------------------------------------------------------------

SYMPTOMS
SQL Server Setup fails during the installation process when it attempts to start SQL Server. Setup shows the following error message in a dialog box before it quits:


The SQL Server installation could not be successfully completed.
Setup could not connect to the SQL server.

The Windows NT event log shows the following error message:

Msg 17113 : initconfig: error 2(The system cannot find the file
specified.) opening 'master.dat' for config information


CAUSE
A previous installation of SQL Server was removed by deleting the files from the SQL Server directory. Manually deleting registry keys and removing files is not the best way to remove SQL Server. Doing this causes any subsequent reinstallation to fail with the following error in the errorlog:

initconfig: error 2(The system cannot find the file specified.) opening
'master.dat' for config information

The "Remove SQL Server option" may also be unavailable in the Setup program, so the only way to correctly reinstall SQL Server is to cleanly remove SQL Server and then reinstall it.

WORKAROUND
To reinstall SQL Server correctly, perform the following steps:

Run "setup /t RegistryRebuild = ON" (without the quotation marks) from the Binn directory under the directory where SQL Server was installed.

This rebuilds the registry and fills in any missing parameters. Type the same information in the setup dialog boxes as the first time SQL Server was installed. Setup will not copy any files or run any scripts, but it will re-create the registry and services as if you had done a full installtion.

Run Setup again, and this time choose to remove SQL Server. This not only removes all the files, but also removes the registry entries.


Reinstall SQL Server normally.

MORE INFORMATION
The RegistryRebuild = ON switch can not only be used in this situation, but also to recover from a situation where the Windows NT registry has been damaged, inadvertently modified, or restored. For more information, see the following article in the Microsoft Knowledge Base:


Q157805 : BUG: RegistryRebuild Option of Setup Is Not Documented

Additional query words: regrebuild rebuildregistry gray grey greyed grayed disabled
input enter

Keywords : kberrmsg kbsetup SSrvInst
Issue type : kbprb
Technology :
Hope This Helps
Bernadette