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

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
-
- 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 -
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
All replies
-
- 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 -
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