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

Can't open console after upgrading to SEC 5.2.1

Everything seemed to go smoothly during the upgrades, first from 4.5, then from 5.1.

Upon opening Enterprise Console I get the message: The user "DOMAIN\user" does not have any assigned roles. You must be assigned to at least one role to run the console.

A search of that error takes me to Sophos article 116684  

The article claims running this command: 

<<<  SQLCMD -E -S (local)\SOPHOS -d SOPHOS521 -Q "select * from UserRoles" >>>>

if giving me the output:

ID    UserID  RoleID
----- ------  ------
(0 rows affected)

then the following command should fix the problem:

 <<< SQLCMD -E -S (local)\SOPHOS] -d Sophos521 -Q "insert into UserRoles (UserID, RoleID) values (1,1)" >>>

It doesn't fix anything. Instead I get the output:

Msg 547, Level 16, State 1, Server SERVER\SOPHOS, Line 1

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UserRoles_Roles". The conflict occurred in database "SOPHOS521", table "dbo.Roles", column 'ID'.

The statement has been terminated.

Anyone have a clue, or should I just call support?

Thanks

:41299


This thread was automatically locked due to age.