Monday, June 2, 2008

Enabling Database Trust

"Msg 916, Level 14, State 1, Procedure usp_LatestJumpData, Line 4
The server principal "sql_login" is not able to access the database "Source" under the current security context."

To allow procedures in one database to access data in another >

ALTER DATABASE Source SET TRUSTWORTHY ON;
ALTER DATABASE Reporting SET TRUSTWORTHY ON;

No comments: