locked
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection) RRS feed

  • Question

  • Hi.

     I can't get my reports to work.  Please see the picture:


    Please vote if you find my post useful. Add me on Skype @ christo.skype1

    Wednesday, November 7, 2012 10:29 AM

Answers

  • Hi,

    have a look at this post for some helpful info on troubleshooting reporting errors.

    Greetings,

    Pavlos


    Please mark this reply as an answer and vote it as helpful if it helps you find a resolution to your problem.
    View my latest gallery contribution here.
    Visit my blog here.


    Wednesday, November 7, 2012 10:36 AM
  • Hi Pavlos

    Yes I  have, but I did not find the answer.  However, I did manage to my issue.  The answer is actually on that post but not exactly clear.  I had to go to my Domain Controller server and make the SQL user a member of the following groups:

    PrivReportingGroup

    PrivUserGroup

    ReportingGroup

    SQLAccessGroup.

    The privUserGroup is not on the post, after adding it all was fine.


    Please vote if you find my post useful. Add me on Skype @ christo.skype1

    Thursday, November 8, 2012 7:23 AM

All replies

  • Hi,

    have a look at this post for some helpful info on troubleshooting reporting errors.

    Greetings,

    Pavlos


    Please mark this reply as an answer and vote it as helpful if it helps you find a resolution to your problem.
    View my latest gallery contribution here.
    Visit my blog here.


    Wednesday, November 7, 2012 10:36 AM
  • Hi Pavlos

    Yes I  have, but I did not find the answer.  However, I did manage to my issue.  The answer is actually on that post but not exactly clear.  I had to go to my Domain Controller server and make the SQL user a member of the following groups:

    PrivReportingGroup

    PrivUserGroup

    ReportingGroup

    SQLAccessGroup.

    The privUserGroup is not on the post, after adding it all was fine.


    Please vote if you find my post useful. Add me on Skype @ christo.skype1

    Thursday, November 8, 2012 7:23 AM