An exception was thrown while activating Aras.Server.Core.EditItemModule after restoring the DB

Hi,

It seems this error can occur when your database is corrupted, or is restored without the post-restore SQL queries. I'd recommend running the following queries on the database giving you issues.

-- Query 1 (should succeed)
sp_change_users_login 'Update_One','innovator','innovator'
GO
sp_change_users_login 'Update_One','innovator_regular','innovator_regular'
GO

-- Command(s) completed successfully.
-- Query 2 (should fail)
sp_grantdbaccess 'innovator','innovator'
GO

-- Msg 15023, Level 16, State 1, Line 1
-- User, group, or role 'innovator' already exists in the current database.
-- Query 3 (should succeed)
sp_addrolemember 'db_owner','innovator'
GO

-- Command(s) completed successfully.

Hi,

It seems this error can occur when your database is corrupted, or is restored without the post-restore SQL queries. I'd recommend running the following queries on the database giving you issues.

-- Query 1 (should succeed)
sp_change_users_login 'Update_One','innovator','innovator'
GO
sp_change_users_login 'Update_One','innovator_regular','innovator_regular'
GO

-- Command(s) completed successfully.
-- Query 2 (should fail)
sp_grantdbaccess 'innovator','innovator'
GO

-- Msg 15023, Level 16, State 1, Line 1
-- User, group, or role 'innovator' already exists in the current database.
-- Query 3 (should succeed)
sp_addrolemember 'db_owner','innovator'
GO

-- Command(s) completed successfully.