Hi, I'm new to MSSQL Express 2005.
I have a website (ASP.NET 2.0) accessing DB, in the mean time Windows Service tries to update some data in the same DB (Service runs as NT AUTHORITY\LOCAL SYSTEM). The second connection is rejected: "Cannot open user default database. Login failed.Login failed for user ....".
Problem occurs only when both: service and website are running at the same time. So service and website are running without problems when they are connecting DB exclusively.
My connection string is:
"Data Source=.\SQLEXPRESS;AttachDbFilename="|DataDirecto ry|\spider-lab.mdf";Integrated Security=True;User Instance=True"

I would be grateful if you can help.