Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

initconfig: Error 32(The process cannot access... Expand / Collapse
Author
Message
Posted Wednesday, January 8, 2003 9:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 8:51 PM
Points: 53, Visits: 73
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
Posted Wednesday, January 8, 2003 10:17 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 22, 2014 1:22 PM
Points: 8,369, Visits: 734
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
Posted Wednesday, January 8, 2003 2:27 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 8:51 PM
Points: 53, Visits: 73
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
Posted Wednesday, January 8, 2003 2:45 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 22, 2014 1:22 PM
Points: 8,369, Visits: 734
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
Posted Tuesday, October 9, 2012 7:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:06 PM
Points: 23, Visits: 280
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 »

Add to briefcase

Permissions Expand / Collapse