11: View Connection Server Events Database

As we created a SQL Express installation for View Composer we can set the VCS to use this for events logging.  On the View Composer Server open osql and run through these commands

C:\Program Files\Microsoft SQL Server\110\Tools\Binn>osql -E
1> create database VCSEvents
2> go
1> use VCSEvents
2> go
1> create login [vcsuser] with password=N'vcsuser!0', default_database=VCSEvents
, default_language=us_english, check_policy=off
2> go
1> create user [vcsuser] for login [vcsuser]
2> go
1> sp_addrolemember [db_owner], [vcsuser]
2> go
1> use msdb
2> go
1> create user [vcsuser] for login [vcsuser]
2> go
1> quit

In View Administrator in the left hand pane expand View Configuration and click on Event Configuration.  Then click Edit under the Event Database section in the right hand pane

Enter the details created above

image

Normally I would use a Syslog server but the advantage of configuring this is that you get a completely green status panel

image