I have a web app I am running. all of my other web pages work just fine and access the database just fine. but when I click on a new page I get this error. I can then go out and access other pages that access db just fine again.
I must add, the other pages use regular data calls, but this 'problem' page is using Linq.
I look in the sql log and see:
2010-04-20 18:03:28.90 Logon Login failed for user 'WORKLAPTOP\username'. [CLIENT: <named pipe>]
2010-04-20 18:04:13.53 spid51 Error: 17207, Severity: 16, State: 1.
2010-04-20 18:04:13.53 spid51 FCB::Open: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\db1.mdf'. Diagnose and correct the operating system error, and retry the operation.
I did go into my:
C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
and delete everything and restart.