3.9. Procedure – Configuring Microsoft SQL Server to accept logs from syslog-ng
Complete the following steps to configure your Microsoft SQL Server to enable remote logins and accept log messages from syslog-ng.
Start the SQL Server Management Studio application. Select.
Create a new database.
In the Object Explorer, right-click on theentry and select .
Enter the name of the new database (for example
syslogng) into the field and click .
Create a new database user and associate it with the new database.
In the Object Explorer, select, right-click on the entry, then select .
Enter a name (for example
syslog-ng) for the user into the field.
Select theoption and enter a password for the user.
In thefield, select the database created in Step 2 (for example
In thefield, select the language of log messages that you want to store in the database, then click .
Incorrect language settings may result in the database converting the messages to a different character-encoding format. That way the log messages may become unreadable, causing information loss.
In the Object Explorer, select, then right-click on the new login created in the previous step, and select .
Select. In the option, check the line corresponding to the new login (for example
syslogng). In the field, check the and options.
Enable remote logins for SQL users.
In the Object Explorer right-click on your database server, and select, and set the option to .