To move an existing MSSQL database to a different server simply detach the database from the existing server copy it to the new system and reattach it. After the DB is online simply initialize the database again and update all connection strings: 1. Stop all EventSentry services. If you are not using the collector then all remote agents sho...
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 SQLConnect ...
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 enable ...