Issue
Using Database Initialization to create a new ContinuumDB but get a login error for Andover97. The ContinuumDB is then actually created on the server but is only a shell with no tables existing. The MDF and LDF files are also created.
Environment
Continuum
SQL Server
Cause
Continuum had been uninstalled and then installed again with a newer version ( v1.94). The problem was due to the previous install of Continuum. Due to this the Andover97 user was already created in the SQL Server and at some point the password for this user was changed from the default.
Resolution
After changing the Security\Logins\Andover97 user's password to the default and deleting the ContinuumDB shell, the database was able to be created successfully.