We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda ArchiveOne

ArchiveOne pre-installer presents error ‘preinstall could not set service account as sql admin

  • Type: Knowledgebase
  • Date changed: 2 years ago
Solution #00007342

Scope: 
ArchiveOne Enterprise, v7 or later

Answer:

SYMPTOMS

When running the preinstall for v7, after selecting ‘Use the instance that your previous installation of ArchiveOne was using’ the server presents an error – ‘PreInstall could not set service account as SQL admin.’ And on clicking ok you are prompted to enter SQL login details.

The preinstall log file C2C_PreInstallCheck.log will also display the following message –

21/08/15 14:44:46 DoPrep::DatabaseExists returning True for C2CAOneConfig

21/08/15 14:44:46 DoPrep::DatabaseExists returning True for C2CBrowseArchiveFolders

21/08/15 14:44:46 DoPrep::DatabaseExists returning True for AOnePartitionData

21/08/15 14:44:46 DoPrep::DatabaseExists returning True for AOneAudit

21/08/15 14:44:47 AddUserAsDbOwner 'The server principal 'MYDOMAIN\ArchiveOneAdmin' already exists.'

21/08/15 14:44:47 AddUserAsDbOwner 'The proposed new database owner is already a user or aliased in the database.'

21/08/15 14:44:47 DoPrep::CreateDatabase failed to set service account as SQL admin

21/08/15 14:44:47 DoPrep::CreateDatabaseAsUser Domain: 'MYDOMAIN' Account: 'ArchiveOneAdmin'


ROOT CAUSE

At some point the service account has been added to one of the sql databases as a user.


RESOLUTION

For each ArchiveOne database (AOneAudit, C2CBrowseArchiveFolders, C2CAOneConfig, AOnePartitionData) check and, if present, remove the ArchiveOne service account from the list of users:
  1. Log into SQL Server Management Studio (SSMS).
  2. Expand the ArchiveOne databases listed in the preinstall check log.
  3. Expand the Security node and then Users.
  4. If the ArchiveOne service account is listed, right-click and delete the user entry.
  5. Click ‘OK’ to commit the delete.
  6. Repeat for all the ArchiveOne database and then close SSMS.
  7. Now re-run the preinstaller to confirm the error is resolved.


Link To This Page: