Database for SQL Instance

Hello razvan21,

if you can open the console and work with it then there's nothing else to do (except perhaps to revise the policies)

Christian 

After I upgrade I could not open the console.

I put the user "SophosDatabaseUser" (user created before upgrade) to the Sophos DB Admins group and I open the console with no problems.

Hello razvan21,

so it is working now? Probably a glitch (it should have been put in the group by the installer AFAIK). Anyway - once it works it should continue to do so.

Christian

Yes it's working.

My SCCM server notify me:

Alert: Database Offline

Source: SOPHOS45

Path: serversophos.domain.com;SOPHOS

Last modified by: System

Last modified time: 01.08.2012 13:46:51

Alert description: Database SOPHOS45 in SQL Server instance SOPHOS on computer serversophos.domain.com is offline/recovery pending/suspect/emergency

What it is this message?

Thank you

Hello razvan21,

you probably don't need to monitor the SOPHOS45 database any longer. Did you do anything special with it as the upgrade - guess you left it as it is? Note that if auto-close is set on the database (which is AFAIK the default for Express) it will be closed as SEC5.1 no longer uses it. Heard that this could cause the message if it is still being monitored.

Christian

Hello,

I left as it.

I not changed anything.

As you no longer need (for production) it you should stop monitoring it (and perhaps consider dropping it)

Christian

ok, thank you.