Can't Connect SQL server - process being used by another process. Conflict with IIS?
- by shinya
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