SQL ULSTraceLog Tables and View don’t exist!

So I turned on event logging, and configured a collection schedule. But that did not turn on the data collection for my trace logs (the 14\Logs\<server>-<date>-<time>.log  files).

To get the trace logs collection, we must turn on Web Analytics.

Go into Central Administration, click Manage service applications

Select New on the ribbon (Fluent UI) and choose Web Analytics Service Application.


I had to use two screen shots to get the new dialog. Here it is. Configure your Application Pool and identity. Then enter your database information. Finally, configure your data retention period.

Now that you have your Web Analytics Service Application configured, you will see your ULSTraceLog tables/view in SQL Server. Now get ready for reporting!!



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: