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
This thread was automatically locked due to age.