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

Filed under:
|
|

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

Related posts about sql-server

Related posts about iis