Enterprise Console. Broken upgrade from 4.0 to 4.5

Hi,

I have 4 points to note and things to try.

1.  You say:

  "2 DB instances: SOPHOS4 and SCE2010."

I assume SOPHOS4 is the database and from the command that got run SOPHOS is the name of the instance.  

Can you confirm this?

2.  The command that got run looks incorrect if this SQL server is a domain member.

I think it should have been:

InstallDB NFBMGM\SOPHOS <DOMAINNAMESHORT> SOPHOS45 InstallDB.log

As based on the error you had: NFBMGM must be the name of the SQL server?

3. I'm surprised the account that tried to create the database didn't have sufficient privileges.

Is this a domain member, were you logged on as a local admin or the domain admin?

If you install SQL Server Management Studio and connect to the SOPHOS instance, if you browse to:

Security\Server roles\

select the properties of the sysadmin role.

Who do you have in there, system and the administrators group, to which the installing account was a member? 

I would sort that out first and then, as a test if you run the following:

Do you get the same error or does it create the database test?

If it does you can drop the test database with:

C:\>osql -E -S NFBMGM\sophos

1> drop database test

2> go

1> quit

It might be worth trying to create the database before changing any of the security just to see if you get the same error as thrown by the installer, and then if you change the security does it create the database ok?

4. As for just SUM product remaining.  I assume the following happened:

1. The SEC components of version 4  were removed as the first part of the update.

2. The database failed as part of the SEC 4.5 install but at that point SEC4 had gone so it rolled back to nothing apart from SUM.

3. Does SUM appear in add or remove programs?  It looks like you need to remove it before having another go at installing 4.5.

If does not appear, does the key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{2C7A82DB-69BC-4198-AC26-BB862F1BE4D0}

exist?

In which case you can probably just run:

MsiExec.exe /X{2C7A82DB-69BC-4198-AC26-BB862F1BE4D0}

to remove it.

So there are quite a few things to check.

Thanks,

Jak

Hi Jak,

Thank for the great and detail answer.

The problem was effectively that the account I used, which is a domain administrator didn't have the proper right on the database. It was because the SQLServer was installed when the server wasn't in the domain.

I don't know if the Upgrade Advisor check if the account used have the proper rights on the DB...

When EC 4.5 rolled back the actions, it f*ed all the DB and server. I had to reinstall the server from my image and then the upgrade went well.

I know this is a bit late in the day, and its an old thread, but I tried:

4. As for just SUM product remaining.  I assume the following happened:

1. The SEC components of version 4  were removed as the first part of the update.

2. The database failed as part of the SEC 4.5 install but at that point SEC4 had gone so it rolled back to nothing apart from SUM.

3. Does SUM appear in add or remove programs?  It looks like you need to remove it before having another go at installing 4.5.

If does not appear, does the key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr​entVersion\Uninstall\{2C7A82DB-69BC-4198-AC26-BB86​2F1BE4D0}

exist?

In which case you can probably just run:

MsiExec.exe /X{2C7A82DB-69BC-4198-AC26-BB862F1BE4D0}

to remove it.

Low and behold, my 2 days of trying to sort it are over.  Excellent.

Thanks Jak

Alan