Cannot Open Sophos Enterprise Console After upgrade to version 5

Question

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.

This thread was automatically locked due to age.

jak · Accepted Answer

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