Hi Guys,

Did anyone solve this issue ???

I am going through the same issue... And really stuck...

Have tried everything as per kb..

Using Sql Server 2005 on Windows Server 2003 Service Pack...

Since we are using sql server 2005 we forgot to enable TRUSTWORTHY bit

ALTER DATABASE [DB_NAME] SET TRUSTWORTHY ON

u can check this blog w.r.t TRUSTWORTHY

http://blogs.msdn.com/b/sqlsecurity/archive/2007/12/03/the-trustworhy-bit-database-property-in-sql-server-2005.aspx

I got it resolved

Sorry for that...

The requirement it self is my question.

Also editing the above post