Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 6 replies
  • Subscribers 1 subscriber
  • Views 3729 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

New Install 4.7 Management Service won't start

JD4

Ok, getting kinda stuck on this.

Clean install of server 2008 R2

Clean install of SQL Express 2008 R2

All updates applied

New install of Sophos 4.7

Management service will not start.

I connect to the database with management studio and there is no sophos47 database. So, clearly that's why the management service is not starting.

The accounts being used have proper authority, so I'm not seeing why the database portion of the install is failing to setup.

:14613


This thread was automatically locked due to age.
  • 0

    HI,

    What does the application event log entry say when you attempt to start the Sophos Management Service?

    Regards,

    Jak 

    :14615
  • 0

    Getting two errors in the event log:

    There is no database connection. Management Service will be shut down.

    Initialization failed.
    Step: Creating a database connectionError: std::runtime_errorData: Cannot open database "SOPHOS47" requested by the login. The login failed.

    :14623
  • 0

    an additional event in the log:

    Initialization failed.
    Step: Creating a database connectionError: std::runtime_errorData: Could not find stored procedure 'dbo.GetInterfaceVersion'.

    :14625
  • 0

    Is the string value:

    "HKLM\Software\wow6432node\Sophos\EE\Management Tools\DatabaseConnectionMS "

    correct, it must have SOPHOS47 in it as the "Initial Catalog" but is the "Data Source" correct?  Is that where the SOPHOS47 database resides?

    Can you paste the contents of that that key here?

    Regards,

    Jak 

    :14627
  • 0

    The contents of that key is:

    Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS47;Data Source=ENERGYSAV\sqlexpress;

    I can connect to SQL Express using that exact data source with the same account as I used for setting up Sophos. I think I mentioned up higher the SOPHOS47 database doesn't exst.

    :14659
  • 0

    Suddenly Successs!!!

    I started over completely after my previous post with a fresh install of SQL Express and Sophos. I really don't have an understanding of why, other than I was very carefull to use the special account I created for everything during the install this time and now the management service is running and the console is opening.

    :14663