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

Cannot Open Sophos Enterprise Console After upgrade to version 5

ChrisPaulin

I successfully upgraded my Sophos Enterprise Console to 5.0

Now I can’’’’t open Enterprise Console.

It said that my user does not have any assigned role which
is weird because it was working before and when I checked all Sophos related
group, my user was part of it.

Thanks in advance.

:22465


This thread was automatically locked due to age.
  • 0

    Hi,

    What is the result of running the command:

    sqlcmd -E -S .\sophos -d SOPHOS50 -Q "SELECT * FROM dbo.UserRoles "

    You should at least have:

    ID UserID RoleID

    1  1      1

    This maps the Sophos Full Administrator role to the user.  I'll assume your a member of the Sophos Full Administrators group in some way as it all worked before.  The upgrade doesn't touch groups, so I can only think it must be something in the database.

    If you don't have that returned you can run:
    SQLCMD -E -S .\sophos -d SOPHOS50 -Q "INSERT INTO UserRoles (UserID, RoleID) VALUES (1, 1)"

    to remap the role.

    The above queries assume that:

    You have an SQL instance called SOPHOS
    You run the command locally to the SQL instance. 

    Hope that does it.

    Regards,

    Jak

    :22467
  • 0

    Running the first SQL command resulted an error.

    Running the second SQL command to remap the role fix the problem. Probably something during the upgrade of the database.

    Thanks jak!

    :22469
  • 0

    HI,

    Glad it worked out!

    I'm surprised the first query resulted in an error if the second one worked.

    Running:

    sqlcmd -E -S .\sophos -d SOPHOS50 -Q "SELECT * FROM dbo.UserRoles "

    now at least, should return the record you inserted. i.e. the 1,1,1.

    Maybe try:

    sqlcmd -E -S .\sophos -d SOPHOS50 -Q "SELECT * FROM UserRoles "

    Maybe it didn't like the dbo part  (not in the second query) but that would be odd as well.

    I guess it doesn't really matter but odd all the same.

    Regards,

    Jak

    :22477