之乎者也,阿弥陀佛

软件设计的原则就是,化繁为简,化难为易,把人的思维集中在简单的领域,然后通过有序的组合实现复杂的逻辑。

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

Exception Message:

The activated proc [dbo].[storedprocedure_name] running on queue [QUEUE_NAME] output the following:  'The server principal "sa" is not able to access the database "AnotherDBName" under the current security context.'

 

SOLUTION:

The problem is that the activation execution context is trusted only in the database, not in the whole server, like other stored procedures or DB. So when the activated SP calls another SP located in the other DB, the above exception will occur.

 

The simplest solution is to mark the database [SERVICE PROGRAM RUNNING ON IT] as trustworthy.

ALTER DATABASE [DBNAME] SET TRUSTWORTHY ON

posted on 2011-08-31 17:09  搏击的小船  阅读(294)  评论(0编辑  收藏  举报