none
BizTalk Send port calls SQL procedure RRS feed

  • Question

  • Hi All,

    I have a biztalk interfae which calls SQL stored procedure. The User i use for calling the stored procedure is having sufficient permission for the concerned database.

    However, I got an error Server user 'ACB' is not a valid user in database 'Service'.

    This seems strange as i do not have any reference from my database to service database. How is it possible?


    Cheers, Pranav
    Wednesday, September 8, 2010 5:42 AM

Answers

  • Are there any synonyms or other linked objects related to the service database? Maybe a view that refers to tables in the service database, etc. It sounds like there must be a reference to the Service database somewhere.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Wednesday, September 8, 2010 10:50 PM
    Moderator