Office Project Server 2007 Database Auto Closure

[HarryZheng]

If you install Office Project Server with all the default options, you will most likely end up with an SQL Server 2005 Express edition at the back end. These Project Server databases have AutoClose option set to True by default, and it can generate a lot of error messages in the event log. Basically the error messages point out that the specified databases were not readly available, or responding in a timely fasion, when Project Server tried to connect.

To get rid of these error messages, simply change the AutoClose option to False from SSMS.

And better than that, you can import Microsoft Best Practice policies and run the check AutoClose policy against all your Project Server databases. You will need to have access to at least one SQL Server 2008 instance to run the policy.