Sophos Management Service Error

I would think the management service is taking exception to the unexpected database.  The ESC and SBS databases are very similar but not to the point where you can point the management service at either.  That being said there is no migration from SBS to ES unfortunately but we can do things before to minimize the churn required, e.g.. save you having to reprotect all the clients.  Sadly at the moment I don't have quite enough information.

As a bit of information, the names of the Sophos databases are as follows for the different products:

SBS2 =  SOPHOS2
SBS4 =  SOPHOS4

ES 3  = SOPHOS3
ES4  = SOPHOS4
ES4.5 = SOPHOS45

So you can see SBS and ES4 have the same database name.

Before I suggest anything can you run:
OSQL -E -S .\SOPHOS -Q "SELECT Name from sysdatabases"

and post the results?  I assume in the above command the instance in use is called SOPHOS.

The following 2 articles will help you to establish the instance name being used and the version of SQL it is contained within.
http://www.sophos.com/support/knowledgebase/article/113030.html
http://www.sophos.com/support/knowledgebase/article/113034.html
can you obtain this information also?

Also, what version of ES did you have, SEC 3 or SEC 4?

Do you have any other products such as PureMessage that are using the same database instance?

I'd like to suggest removing the existing database instance but I don't have enough information to know if this is safe.  If you could I would, SBS will install a SOPHOS instance of SQL Express.

The process would be something like:

1. Backup the cert auth store
HKEY_LOCAL_MACHINE\SOFTWARE\[wow6432node]\Sophos\Certification Manager\CertAuthStore

2. Uninstall ES
3. Remove the database.
4. Reboot is probably a good idea
5. Check that the above backed up key is still present on startup.  It should be but at least it's backed up if not.  If it's not reimport it.
6. Install SBS
7. With the certificates being the same, the clients should start to appear in the SBS console as they message in.

Regards,

Jak

I would think the management service is taking exception to the unexpected database.  The ESC and SBS databases are very similar but not to the point where you can point the management service at either.  That being said there is no migration from SBS to ES unfortunately but we can do things before to minimize the churn required, e.g.. save you having to reprotect all the clients.  Sadly at the moment I don't have quite enough information.

As a bit of information, the names of the Sophos databases are as follows for the different products:

SBS2 =  SOPHOS2
SBS4 =  SOPHOS4

ES 3  = SOPHOS3
ES4  = SOPHOS4
ES4.5 = SOPHOS45

So you can see SBS and ES4 have the same database name.

Before I suggest anything can you run:
OSQL -E -S .\SOPHOS -Q "SELECT Name from sysdatabases"

and post the results?  I assume in the above command the instance in use is called SOPHOS.

The following 2 articles will help you to establish the instance name being used and the version of SQL it is contained within.
http://www.sophos.com/support/knowledgebase/article/113030.html
http://www.sophos.com/support/knowledgebase/article/113034.html
can you obtain this information also?

Also, what version of ES did you have, SEC 3 or SEC 4?

Do you have any other products such as PureMessage that are using the same database instance?

I'd like to suggest removing the existing database instance but I don't have enough information to know if this is safe.  If you could I would, SBS will install a SOPHOS instance of SQL Express.

The process would be something like:

1. Backup the cert auth store
HKEY_LOCAL_MACHINE\SOFTWARE\[wow6432node]\Sophos\Certification Manager\CertAuthStore

2. Uninstall ES
3. Remove the database.
4. Reboot is probably a good idea
5. Check that the above backed up key is still present on startup.  It should be but at least it's backed up if not.  If it's not reimport it.
6. Install SBS
7. With the certificates being the same, the clients should start to appear in the SBS console as they message in.

Regards,

Jak