Products
Webtrends Analytics 9.x
Webtrends Analytics 8.x
Issue
During troubleshooting, it is occasionally necessary to access either the wtmaster or wt_sched database or its properties using MS SQL Management Studio. In some circumstances, an error similar to the following may display while trying to access the database properties:
Property Collation is not available for the database ‘[wtmaster]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
When this message displays, the database will not be accessible.
Cause
This is SQL connection failure results from insufficient rights of the currently logged-on user.
Resolution
Log out, then log in using the Webtrends Service account used by the Webtrends services. This account should have sufficient rights to the SQL database.