locked
System.Data.SqlClient.SqlException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM RRS feed

  • Question

  • Dear ALL 

    After successfully shifting the CRM from 2011 to 2013 i found a problem in Reporting section none of the report is working after some finding i conclude that MSCRM_FetchDataSource is not able to connect successfully 

    Through my report manager i tried to test the connection of MSCRM_FetchDataSource but i got the following error 

    System.Data.SqlClient.SqlException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM'. 

    I already add the NT Authority \ System as a db_owner under my database user of MSCRM_CONFIG

    But still no success any one have any idea why it's happaning 

    Regards 


    RB

    Wednesday, January 28, 2015 7:54 AM

Answers

  • I found a solution I hope my post will help other

    I gave the  db_owner to 'NT AUTHORITY\SYSTEM' and 'NT AUTHORITY\NETWORK' and assigned with both CRM and Config database

    It resolved my issue


    RB

    Tuesday, February 3, 2015 12:52 PM