Microsoft SQL Server hints

Logs of the Windows event log:

• Error Event „Report Server Windows service (SQLEXPRESS) can't connect to reporting server - database. “
• At the SQL Configuration Manager at SQL Server 2005 services stop the SQL Server Reporting Services (SQLEXPRESS) and change the start mode to "Manual". The Reporting Service won't be needed from the TwinCAT Database Server.
• Information Event „'"Databasename"'-database will be started “
• At the SQL Server Management Studio Express at Databases/"Databasename" rigth click -> properties and at options change the option "Automatic close" from "True" to "False". This option won't be needed, the TwinCAT Database Server will open and close the database automatically.

It is possible to blanket the logging into Windows event log. Then events from the SQL Server won't be logged. You can't choose which kind of event will be logged and which not.

• At the SQL Configuration Manager at SQL Server 2005 Services choose the SQL Server (SQLEXPRESS) and then right click -> properties. The "Advance" tab contains the subitem "Startup Parameters". The different parameters are separated with semicolons. Add the parameter -n and restart the service.

At this moment no events from the SQL Server will be logged to the Windows event log.