You may encounter one of the following errors: OdbcExpandError: 28000MicrosoftSQL Native ClientSQL ServerLogin failed for user 39eventsentrysvc39. 18456 at SQLConnect OdbcExpandError: 42000MicrosoftSQL Native ClientSQL ServerCannot open database EventSentry requested by the login. The login failed 4060 at SQLConnec...

KB-ID 149
Category: Database
Applies to: All Versions

When using Microsoft SQL Server with EventSentry we recommend setting up a Maintenance Plan to continually check integrity reduce index fragmentation and periodically shrink the database to free up unused disk space. The following instructions assume the SQL Server Agent is running and Agent XPs is set to enabled. For instructions to enabl...

KB-ID 220
Category: Database
Applies to: All Versions