When you check the events, you see the annoying event pops up every few minutes. I finally figured out how to solve it.
The reason was caused by Microsoft for some reason setup the Auto Close option to default. So the database wasn't used for a while, it will be closed automatically. Once programm call it, it will up again.
To turn it off, following these steps:
With your SQL Server Studio:
- Open SQL Management Studio and connect to the instance that hosts the WebMarshal database.
- In the left pane expand Databases, right-click the WebMarshal database, and select Properties.
- From the Properties window, select Options.
- Under the heading Automatic, change "Auto Close" from True to False.
- Click OK to apply the change.
Or you can run a query to set it:
ALTER DATABASE [your database name] SET AUTO_CLOSE OFF WITH NO_WAIT
Notes:
This is not the error in event.