Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 3 subscribers
  • Views 22673 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Database Issue with upgrading from 5.4.1 to 5.5.0

sabdul

 hello,

Today I decided to upgrade from 5.4.1 to 5.5.0 so for some reason the install went through just fine however the database did not upgrade so for this reason, services are not starting. When I click on the setup again this is the error I'm getting.

 

My user does have access to the database. I've been doing upgrades on this same user account. This is a sysadmin account. 

For the second error, "The logon user cannot access the database created during a previous installation" Sophos suggested the following

  1. Open Regedit (Start | Run Type: Regedit.exe | Press Return)
  2. Browse to HKLM\Software\Sophos\EE\Management Tools\Database Installer
  3. Edit the registry string 'Instance'
  4. Delete the value 'MSSQLSERVER' and click OK
  5. Run the Enterprise Console installer

As you can see below, I do not see the Database Installer folder or "Instance" string. 

 

So basically now when I open Sophos Enterprise Console after a minute of it trying to connect to the server, I get the following error because the database is not upgraded. 



This thread was automatically locked due to age.
Parents
  • 0

    Hello sabdul.

    is the Sophos Management Database listed under Programs and features and if so, which version?
    And what is the value for Initial Catalog in DatabaseConnectionMS?

    Christian

  • 0 in reply to QC

    Hi Christian,

    It is not listed. This is all listed in Programs and Features and the value for DatabaseConnectionMS is Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS550;Data Source=(local)\SOPHOS;

  • 0 in reply to sabdul

    I also tried to run upgradedb.exe with the following command "upgradedb.exe -debug -sourceVersion=540" and I got Failed to transfer data from the old database error. 

  • 0 in reply to sabdul

    Hello sabdul,

    is there a Sophos_Database64msi log belonging to the upgrade?
    Do the database files (SOPHOS550.mdf, SophosSecurity.mdf, SOPHOSPATCH52.mdf) exist (sqlcmd.exe -E -S .\SOPHOS -Q "select name, filename from sysdatabases")?
    If so, try to (re-)install only the database component using the CREATE_DATABASES=0 property as outlined in Scenario 1/3 in this article (note: the installer directory is \sec_550 in your case). Then run upgradeDB.exe -reset and afterwards start the services and try to open the console.

    Christian

  • 0 in reply to QC

    Hi Christian,

    I do not see any logs for Sophos_Database64.msi in the event logs. I only see Event 8004

    Initialization failed.
    Step: Creating a database connection
    Error: std::runtime_error
    Data: Could not find stored procedure 'dbo.GetInterfaceVersion'.

     

    Also these 3 files, don't exist. I assume you wanted me to run this command to find each file 

    sqlcmd.exe -E -S .\SOPHOS -Q "filename.mdf"

  • 0 in reply to sabdul

    Also, just an fyi, I do see the 550 database on the sql server

  • 0 in reply to sabdul

    Hello sabdul,

    you wanted me to run this command
    no, seems you are not really familiar with SQL. The string following the -Q is a SQL Query, this is not what you'd normally understand by query     (it could also be something like DROP DATABASE xxxx). With it you tell the database instance what you want it to do for you. The particular command means: Show me the contents of the name and filename columns from the sysdatabases table (the name contains the database name and the filename the complete path of the DATA file(s)).

    With the log I meant the install logs in %ProgramData%\Sophos\Management Installer\.

    From your other post it seems that the database is there, the 8004 suggests that it might not be properly initialized. And furthermore the database component is not under Programs and Features. Before making another suggestion I'd like to see the msi log though.

    Christian

Reply
  • 0 in reply to sabdul

    Hello sabdul,

    you wanted me to run this command
    no, seems you are not really familiar with SQL. The string following the -Q is a SQL Query, this is not what you'd normally understand by query     (it could also be something like DROP DATABASE xxxx). With it you tell the database instance what you want it to do for you. The particular command means: Show me the contents of the name and filename columns from the sysdatabases table (the name contains the database name and the filename the complete path of the DATA file(s)).

    With the log I meant the install logs in %ProgramData%\Sophos\Management Installer\.

    From your other post it seems that the database is there, the 8004 suggests that it might not be properly initialized. And furthermore the database component is not under Programs and Features. Before making another suggestion I'd like to see the msi log though.

    Christian

Children
No Data
Unfiltered HTML