locked
The EXECUTE permission was denied on the object 'p_GetCrmUserId', database 'MSCRM_CONFIG', schema 'dbo'. RRS feed

  • Вопрос

  • Hi all!

    We are facing a strange problem in 2 environments - one is our own and one is at a client site in a prod environment - in both cases the problem started after upgrading to UR12:

    error description:

    1.       Create new report using the report wizard (Inside the CRM)
    2.       Publish the report for external use 
    3.       Open reporting services manager web site
    4.       Open the report
    5.    We get the following error message:

    An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
    System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'p_GetCrmUserId', database 'MSCRM_CONFIG', schema 'dbo'.
    The EXECUTE permission was denied on the object 'p_GetCrmUserId', database 'MSCRM_CONFIG', schema 'dbo'.

    Any help would be appreciated!

    Thanks!

    19 февраля 2013 г. 15:46

Ответы

  • Hello, 

    While I don't know about your environment specifically and what may have caused this issue, have you tried:

    1. Open SQL management studio, connect to your instance hosting MSCRM databases

    2. Open MSCRM_CONFIG

    3. Open Programmability

    4. Open Stored Procedures

    5. Select DBO.p_GetCrmUserId, right click and open properties.

    6. In the Permissions tab, add the service account set in your SSRS options, and grant it the execute permission on the stored procedure.

    Best Wishes,

    Alex

    • Предложено в качестве ответа AlexAquila 20 февраля 2013 г. 19:37
    • Помечено в качестве ответа Tzooki 21 февраля 2013 г. 8:11
    20 февраля 2013 г. 19:36

Все ответы

  • Having the identical issue on my end, started after upgrading to UR12 On-Premise

    20 февраля 2013 г. 0:42
  • Hello, 

    While I don't know about your environment specifically and what may have caused this issue, have you tried:

    1. Open SQL management studio, connect to your instance hosting MSCRM databases

    2. Open MSCRM_CONFIG

    3. Open Programmability

    4. Open Stored Procedures

    5. Select DBO.p_GetCrmUserId, right click and open properties.

    6. In the Permissions tab, add the service account set in your SSRS options, and grant it the execute permission on the stored procedure.

    Best Wishes,

    Alex

    • Предложено в качестве ответа AlexAquila 20 февраля 2013 г. 19:37
    • Помечено в качестве ответа Tzooki 21 февраля 2013 г. 8:11
    20 февраля 2013 г. 19:36
  • Thanks Alex - that solved it!

    Although i find it very strange - the SSRS are running under NETWORK SERVICE which already has permissions for MSCRM_CONFIG - and nothing changed besides the UR12 upgrade.

    I don't understand why all of a sudden it requires EXECUTE permissions - maybe they missed something in this rollup...

    Thanks for the help!

    21 февраля 2013 г. 8:14
  • This could be caused if the installer is doing a "DROP PROCEDURE" followed by a "CREATE PROCEDURE" during the installation, rather than an ALTER PROCEDURE. Not sure why that would be the case though, offhand. In any case, glad that resolved your issue :)
    21 февраля 2013 г. 23:33
  • Hi Alex,

    i am a little bit confused, if this change is a intentional change of the permissions by microsoft or not.

    The change of SQL-Permissions should be unsupported, so i am not realy sure if i should implement this at our customers environment, cause he has the same issue ...
    Have you seen any UR 12 Deployment where this permission was set without setting it manually?

    Kind Regards
    Thomas

    21 марта 2013 г. 13:22
  • Thanks Alex , it solved my problem.
    7 декабря 2013 г. 17:10