SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Sdude
Sdude
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 74
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.



Antares686
Antares686
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: Moderators
Points: 26130 Visits: 785
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?



Sdude
Sdude
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 74
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.



Antares686
Antares686
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: Moderators
Points: 26130 Visits: 785
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.



Gary Nease
Gary Nease
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 485
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search