initconfig: Error 32(The process cannot access...

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » initconfig: Error 32(The process cannot...

initconfig: Error 32(The process cannot access...

Rate Topic

Display Mode

Topic Options

Author

Message

Sdude

Posted Wednesday, January 08, 2003 9:53 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:13 PM
Points: 53, Visits: 64

Hi everyone , please help!!!

Since yesterday, our SQL started to thowing out this error:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 1/8/2003
Time: 09:31:05
User: N/A
Computer: SQLserver
Description:
17113 :
initconfig: Error 32(The process cannot access the file because it is being
used by another process.) opening 'e:\MSSQL\data\master.mdf' for
configuration information.

Data:
0000: d9 42 00 00 10 00 00 00 ÙB......
0008: 0c 00 00 00 4d 00 49 00 ....M.I.
0010: 54 00 53 00 45 00 52 00 T.S.E.R.
0018: 56 00 45 00 52 00 30 00 V.E.R.0.
0020: 36 00 00 00 00 00 00 00 6.......

When this happened, none of my applications can access the SQL server and
lock up the users that are trying to run the app. I searched Technet and
several news groups on the net, and they all pointed me to the issues with
User Connections settings. However, our server uses the default settings
which allows unlimited connections. I' lost where I should start to fix
this. Has anyone run into this error, and how have you fixed it?

Any help will be greatly appreciated.

Daniel.

Post #9165

Antares686

Posted Wednesday, January 08, 2003 10:17 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

First have you tried restarting the service and the server to see if the issue goes away? In addition are there any other processes that could be hung such as a backup running against master currently?

Post #51120

Sdude

Posted Wednesday, January 08, 2003 2:27 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:13 PM
Points: 53, Visits: 64

Thanks lot, Antares686. Yes after I restarted MSSQLServer and SQLAgent, the lock went away. I have backup job running nightly to backup system databases, including Master. But I've running the job forever and never had such problem. The only change that we made recently is upgrade from SQL7 to SQL2k, but we have been running our app on it without any issues till yesterday.

Thanks.

Post #51121

Antares686

Posted Wednesday, January 08, 2003 2:45 PM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

It may be a fluke that just occurred but check in Event Viewer and SQL Server Logs to see if any other specific event occurred around the time the problem started. Also, check job histories to see if any may have reported an issue or ran extremely long during the time of the condition.

Post #51122

Gary Nease

Posted Tuesday, October 09, 2012 7:12 PM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:26 PM
Points: 23, Visits: 209

This happened to me running SQL2000 under VMWare, running a backup with RedGate HyperBac 5.7.0.155 as the transparent compression. The backup had hung (which has happened twice on this, our only virtual SQL Server) and when I restarted MSSQLServer, Hyperbac still had a lock on master.mdf. I had to kill Hyperbac thru taskmgr (its UI didn't kill it) and then was able to restart MSSQL.

Regards,

Gary

Post #1370647

« Prev Topic | Next Topic »

Permissions