Notes on the Microsoft SQL Server

Logs in the Windows Eventlog

Error Event

"Report Server Windows Service (SQLEXPRESS) cannot be connected to the report server database."

In the SQL Configuration Manager under SQL Server 2005 stop the SQL Server Reporting Services (SQLEXPRESS) and set the Start Mode to "manual". The Database Server doesn't need the Reporting Service.

Information event

"'TcDataLogger' database is started"

Open the Properties via the context menu in SQL Server Management Studio Express under Databases/TcDataLogger and under Options set the option Close automatically to FALSE. This option is not required because the Database Server opens and closes the database automatically.

It is possible to suppress logging to the Windows Eventlog. Events are then no longer logged. No distinction can be made between the different types of event.

Select the SQL Server (SQLEXPRESS) in the SQL configuration manager under SQL Server 2005 Services and open the Properties via the context menu. The Advanced tab contains a Startup parameters subitem. The individual parameters are separated by semicolons. Add the parameter "-n" and restart the service.

From this point onwards no further events will be logged by the SQL Server.