When attempting to check out a standard database in Database Editor, the following message appears:
[Window Title]
Estimating Database Editor
[Main Instruction]
An attempt to check out the database '[Database Name]' was made, but failed.
[Expanded Information]
The server principal "sa" is not able to access the database " '[Database Name]'" under the current security context.
See the Sage Event Viewer message log for more details.
Press CTRL+C to copy the contents of this window.
[^] Hide Details [OK]
- Launch SQL Server Management Studio.
- Right-click on the database
- Select Properties.
- Select the Options page.
- Find Trustworthy under the Miscellaneous section.
If the Trustworthy setting needs to change to FALSE, run this in a New Query window:
ALTER DATABASE DatabaseName SET TRUSTWORTHY OFF
Where 'DatabaseName ' equals the offending database.
Change Trustworthy settings to TRUE:
ALTER DATABASE DatabaseName SET TRUSTWORTHY ON;
Where DatabaseName is the database to be changed.