Spent a while trying to get this to work. I am sure it is in the administration guide somewhere but this is what I found.
The Events database connects using SQL authentication so the SQL Server must be configured to use Mixed Mode authentication. I have been testing with SQL express and the first clue were a lot of errors in the application log. To resolve this do the following
Open the Management Studio -> Right Click on the server and select properties. Set the following
I run a number of community websites and need a reliable, flexible, cost effective server with high availability. VMhosts fits my needs exactly.The customer support and communication is first class. The team at VMhosts were really helpful when I was setting up the server, and all my queries since then have been answered informatively and promptly.