Can't Connect SQL server - process being used by another process. Conflict with IIS?
Posted
by
shinya
on Server Fault
See other posts from Server Fault
or by shinya
Published on 2012-09-23T18:56:18Z
Indexed on
2012/09/23
21:39 UTC
Read the original article
Hit count: 224
I'm having problem connecting to MS SQL Server (2012 Express) after accessing a database through IIS (web site). I can access the data through web site no problem, but I can't access the data from any other programs (i.e SSMS) until I reboot the SQL server. It seems that the connection stays open even if I close a browser.
Here is error message I'm getting
Unable to open the physical file "C:---------". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". Unable to open the physical file "C:-------". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". Cannot open user default database. Login failed. Login failed for user 'Myserver\myname'. (.Net SqlClient Data Provider)
Server Name: MYPC\SQLEXPRESS Error Number: 5120 Severity: 16 State: 101 Line Number: 65536
I follow the help link and it told me to move TCP before named pipes in the protocol order list. I tried it but it didn't help at all.
What is the proper settings on SQL server or IIS in order to release process after closing a browser. How do I avoid getting this error?
Thank you for your help
© Server Fault or respective owner