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

Answers

• 

  

  1

  Sign in to vote

  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.

  
  

  • Edited by Pavlos Panagiotidis Wednesday, November 7, 2012 10:38 AM
  • Proposed as answer by Pavlos Panagiotidis Thursday, November 8, 2012 7:26 AM
  • Marked as answer by Christo Vermeulen Thursday, November 8, 2012 7:44 AM

  Wednesday, November 7, 2012 10:36 AM
• 

  

  1

  Sign in to vote

  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

  • Proposed as answer by Pavlos Panagiotidis Thursday, November 8, 2012 7:26 AM
  • Marked as answer by Christo Vermeulen Thursday, November 8, 2012 7:44 AM

  Thursday, November 8, 2012 7:23 AM