Hi
I had 4.7 running fine and had upgraded to 5.1 successfully. Something went wrong during upgrade to 5.2. I now get "unable to install database"
Typing C:\Users\Administrator>sqlcmd -E -S (local)\SOPHOS -Q "SELECT name, filename from sysdatabases" > C:\databases.txt produced:
name filename -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- master C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\master.mdf tempdb C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\tempdb.mdf model C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\model.mdf msdb C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\MSDBData.mdf SOPHOS47 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOS47.mdf SOPHOS51 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOS51.mdf SOPHOSPATCH51 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSPATCH51.mdf SOPHOSENC51 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSENC51.mdf SOPHOS52 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOS52.mdf SophosSecurity C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SophosSecurity.mdf SOPHOSPATCH52 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSPATCH52.mdf SOPHOSENC52 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSENC52.mdf
(12 rows affected)
An extract from the install log is below:
Property(S): USERNAME = Windows User Property(S): DATABASE = C:\Windows\Installer\498c87.msi Property(S): OriginalDatabase = C:\sec_52\ServerInstaller\Database64.msi Property(S): UILevel = 2 Property(S): Preselected = 1 Property(S): ACTION = INSTALL Property(S): ROOTDRIVE = X:\ Property(S): CostingComplete = 1 Property(S): OutOfDiskSpace = 0 Property(S): OutOfNoRbDiskSpace = 0 Property(S): PrimaryVolumeSpaceAvailable = 0 Property(S): PrimaryVolumeSpaceRequired = 0 Property(S): PrimaryVolumeSpaceRemaining = 0 Property(S): INSTALLLEVEL = 1 Property(S): DomainOrComputerName = RAVENSCROFT Property(S): SOURCEDIR = C:\sec_52\ServerInstaller\ Property(S): SourcedirProduct = {785EEA74-C97F-4805-B017-112D88248C97} Property(S): ProductToBeRegistered = 1 MSI (s) (80:C8) [09:44:40:911]: Note: 1: 1708 MSI (s) (80:C8) [09:44:40:912]: Product: Sophos Management Database -- Installation failed.
MSI (s) (80:C8) [09:44:40:913]: Windows Installer installed the product. Product Name: Sophos Management Database. Product Version: 5.2.0. Product Language: 1033. Manufacturer: Sophos Limited. Installation success or error status: 1603.
MSI (s) (80:C8) [09:44:40:915]: Deferring clean up of packages/files, if any exist MSI (s) (80:C8) [09:44:40:915]: MainEngineThread is returning 1603 MSI (s) (80:F0) [09:44:40:915]: No System Restore sequence number for this installation. === Logging stopped: 15/07/2013 09:44:40 === MSI (s) (80:F0) [09:44:40:916]: User policy value 'DisableRollback' is 0 MSI (s) (80:F0) [09:44:40:916]: Machine policy value 'DisableRollback' is 0 MSI (s) (80:F0) [09:44:40:916]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (80:F0) [09:44:40:917]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (80:F0) [09:44:40:917]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (80:F0) [09:44:40:917]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (s) (80:F0) [09:44:40:918]: Restoring environment variables MSI (s) (80:F0) [09:44:40:918]: Destroying RemoteAPI object. MSI (s) (80:D4) [09:44:40:918]: Custom Action Manager thread ending. MSI (c) (2C:2C) [09:44:40:920]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (2C:2C) [09:44:40:921]: MainEngineThread is returning 1603 === Verbose logging stopped: 15/07/2013 09:44:40 ===
Please help.
Charles
This thread was automatically locked due to age.