Saturday, February 25, 2012

Cannot start Microsoft SQL Server agent & Enterprise manager

Hi:
I am receiving the following error message while trying to open Enterprise
Manager in MSSQL 2000 Server.
A connection could not be established to ABCD
Reason : I/O error 1117(the request could not performed because of an I/O
device error.) detected during read at offset 0x00000000b1e000 in file
'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
Please verify SQL Server is running and check your SQL Server registration
properties (by right cliking on the ABCD node) and try again.
This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
3). The MSSQL server service SQL Server Agent services are running under
local system. This is a Standalone machine.
Help is required on an urgent basis as this is a production server.
With Regards
Mitul
You have a problem with the mdf file for your master database file. Possibly the file is locked by
some other process (like anti-virus). If that is the case, try again. If you are unlucky, the master
mdf file is corrupt for some reason, and you have to go the rebuildm.exe route.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mitul" <Mitul@.discussions.microsoft.com> wrote in message
news:46466B5B-D821-4C07-BD8C-8996EBAD7915@.microsoft.com...
> Hi:
> I am receiving the following error message while trying to open Enterprise
> Manager in MSSQL 2000 Server.
>
> A connection could not be established to ABCD
> Reason : I/O error 1117(the request could not performed because of an I/O
> device error.) detected during read at offset 0x00000000b1e000 in file
> 'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right cliking on the ABCD node) and try again.
>
> This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
> 3). The MSSQL server service SQL Server Agent services are running under
> local system. This is a Standalone machine.
> Help is required on an urgent basis as this is a production server.
> With Regards
> Mitul

No comments:

Post a Comment