locked
CRM2011: How Database owner(SA Account) to access CRM entity records? RRS feed

  • Question

  • Hello,

    I have another system which needs to get one CRM entity records information. I have to login CRM database as Database Owner(SA account), which can connect CRM with the other system. But there is no CRM records when login as SA?

    Do you know how to get the related CRM records when login CRM database as Database Owner(SA account)?

    Thanks.

    Thursday, June 27, 2013 3:13 PM

All replies

  • Are you querying against the filtered views?

    If so, they take into account record security and since SA isn't a CRM user account it shouldn't be returning any results.

    So query against the non-filtered views or the tables directly


    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Thursday, June 27, 2013 3:31 PM
    Moderator