Change the Trustworthy Option in SQL Server 2005
Posted on 2007-10-02
I would like to change the Trustworthy option by executing:
ALTER DATABASE DatabaseName SET TRUSTWORTHY ON
But I receive the error:
Msg 5011, Level 14, State 5, Line 4
User does not have permission to alter database 'DatabaseName', or the database does not exist.
Msg 5069, Level 16, State 1, Line 4
ALTER DATABASE statement failed.
But of course, all permissions seem correct and the user is in the sysadmin group. Also, the Trustworthy option is disabled in all databases but it is the only option that is. I can create a new database with the option set to ON.
Any idea how to change the Trustworthy option on an existing database?