Error on User-Specific-Settings

Error on User-Specific-Settings

avatar

Hello,

when I try to save User-Specific-Settings, I got an error back.

Greetings

Martin

All Comments (2)

avatar

@Martin - Could you please send us your DB schema for analysis. File -> Data Sources -> Upgrade (tab) -> "Email Schema to Support"

Please add: "Attn: Stefane" in the subject.

Best regards,

Stéfane Lavergne

avatar

Could it be that this database has been move/restored from a different/same server?

Please run the following:

select name as [DB Name], suser_sname(owner_sid) as [Owner] from sys.databases

where Name = DB_NAME();

GOYou should see something like:DB Name Owner

-------------------- --------------------

RDM null or sa

(1 row(s) affected)

In the case where you see <null> then the issue is due to the database no longer has an "owner" and since we run a few triggers using the "with execute as owner" it is causing the issue.

The solution, run the following:ALTER AUTHORIZATION ON DATABASE::RDM TO sa;

GO(Make sure to replace RDM with your database name and sa with a user you want to own the database. sa is a good option

Let me know if that resolves it for you.

Best regards,

Stéfane Lavergne