Thread Info
  • State Not Answered
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 2 replies
  • Subscribers 2 subscribers
  • Views 1920 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

Cant Start Management Console

JTHoB

Hi everyone,

I just installed the new Sophos Endpoint but cant get it up and running and could use some assistance.

This is the error I get when i try to start the Management Service

"Cannot open database "SOPHOS50" requested by the login. The login failed. "

from the KB i found this article http://www.sophos.com/support/knowledgebase/article/111898.html

which tells me to run a sql command. Unfortunately when I do so, i get the following error:

"Msg 15098, Level 16, State 1, Server Server\SOPHOS, Line 1
The name change cannot be performed because the SID of the new name does not match the old SID of the principal. "

Can anyone assist me in solving this problem?

Thanks in advance

:24297


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

    Hi JTHoB,

    Alternatively try teh steps below.

    In the event that the above has not resolved your issue, please contact support for further assistance.

    1. Remove the user from the instance using the command (edit the DOMAINNAME to be the domainname or servername depending on the location of the Sophos DB Admins group):

      sqlcmd -E -S .\Sophos -Q "IF  EXISTS (SELECT * FROM sys.server_principals WHERE name = N'DOMAINNAME\Sophos DB Admins')DROP LOGIN [DOMAINNAME\Sophos DB Admins]"

    2. Re-add the user using the sql command:

      sqlcmd -E -S .\Sophos -Q "CREATE LOGIN [DOMAINNAME\Sophos DB Admins] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]"

    3. Reinstall the Sophos databases using the scripts:

      C:\Sec50\ServerInstaller\DB\Core\InstallDB.bat
      C:\Sec50\ServerInstaller\DB\Patch\CreatePatchDB.bat

      For instructions on running these scripts, please see article 116768 Creating the Sophos databases using the command line tools
    4. Complete the upgrade and transfer of data to the new databases by running the command:

      C:\Program Files\Sophos\Enterprise Console\upgradedb.exe -debug

      For instructions on running this script, please see article 65420: Using the UpgradeDB.exe tool

    5. Start the Sophos Management Service and Sophos Management Host Service
    :24317
Reply
  • 0

    Hi JTHoB,

    Alternatively try teh steps below.

    In the event that the above has not resolved your issue, please contact support for further assistance.

    1. Remove the user from the instance using the command (edit the DOMAINNAME to be the domainname or servername depending on the location of the Sophos DB Admins group):

      sqlcmd -E -S .\Sophos -Q "IF  EXISTS (SELECT * FROM sys.server_principals WHERE name = N'DOMAINNAME\Sophos DB Admins')DROP LOGIN [DOMAINNAME\Sophos DB Admins]"

    2. Re-add the user using the sql command:

      sqlcmd -E -S .\Sophos -Q "CREATE LOGIN [DOMAINNAME\Sophos DB Admins] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]"

    3. Reinstall the Sophos databases using the scripts:

      C:\Sec50\ServerInstaller\DB\Core\InstallDB.bat
      C:\Sec50\ServerInstaller\DB\Patch\CreatePatchDB.bat

      For instructions on running these scripts, please see article 116768 Creating the Sophos databases using the command line tools
    4. Complete the upgrade and transfer of data to the new databases by running the command:

      C:\Program Files\Sophos\Enterprise Console\upgradedb.exe -debug

      For instructions on running this script, please see article 65420: Using the UpgradeDB.exe tool

    5. Start the Sophos Management Service and Sophos Management Host Service
    :24317
Children
No Data