totoroha
asked on
Business Intelligence and DashBoard report for Sharepoint and Project 2013
Hello everyone,
I will state my situation with Sharepoint and Project Server 2013 in detail so that everyone that has the idea or opinion about fixing it can understand and help me.
I have a Windows Server 2008 R2 installed on Server 1. I installed SharePoint 2013 and project server 2013 and SQL 2012 on Server 2.
The problem that I am confronting right now is the Reports matter. I have 20 members and 5 projects, so 4 members for each project.
Every time we try to create a report, the error is:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
when I click "OK", it opens a new windows as Capture 1.2 that I attached with this post.
I tried to find the solution over the internet, on book such as "Implementing and Administering Microsoft Project Server 2013 for implementers and administrators" by Gary L.Chefetz & Bill Raymond.
I tried to use this instruction but that didn't help much:
http://whitepages.unlimitedviz.com/2012/09/using-per-user-identity-with-reporting-services-and-sharepoint/
The reason for this issue that after so much test-fail solution is that if your computer is domain computer and your user is added to SQL server, you can run the report pretty well.
But in my case, i couldn't add 20 public computers or more into my domain because that will exposed security risks for my system.
I try to look for some solution like proxy or an implementation of gateway that allow the connections from outside to my Project and SharePoint Server.
This issue has been the pain in my neck for almost a month now, i would be grateful for any information or solution that our great members can provide.
Sincerely,
Peter
capture-1.1.JPG
capture-1.2.JPG
I will state my situation with Sharepoint and Project Server 2013 in detail so that everyone that has the idea or opinion about fixing it can understand and help me.
I have a Windows Server 2008 R2 installed on Server 1. I installed SharePoint 2013 and project server 2013 and SQL 2012 on Server 2.
The problem that I am confronting right now is the Reports matter. I have 20 members and 5 projects, so 4 members for each project.
Every time we try to create a report, the error is:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
when I click "OK", it opens a new windows as Capture 1.2 that I attached with this post.
I tried to find the solution over the internet, on book such as "Implementing and Administering Microsoft Project Server 2013 for implementers and administrators" by Gary L.Chefetz & Bill Raymond.
I tried to use this instruction but that didn't help much:
http://whitepages.unlimitedviz.com/2012/09/using-per-user-identity-with-reporting-services-and-sharepoint/
The reason for this issue that after so much test-fail solution is that if your computer is domain computer and your user is added to SQL server, you can run the report pretty well.
But in my case, i couldn't add 20 public computers or more into my domain because that will exposed security risks for my system.
I try to look for some solution like proxy or an implementation of gateway that allow the connections from outside to my Project and SharePoint Server.
This issue has been the pain in my neck for almost a month now, i would be grateful for any information or solution that our great members can provide.
Sincerely,
Peter
capture-1.1.JPG
capture-1.2.JPG
ASKER
Hi Thomas,
Sorry for my late response. I have a business trip abroad so I couldn't focus on this matter. I will double check my system and reply right away.
Thanks.
Sorry for my late response. I have a business trip abroad so I couldn't focus on this matter. I will double check my system and reply right away.
Thanks.
ASKER
Wow, I don't know why but my post wasn't show up here so I will repeat it again.
I use the built-in excel report of sharepoint 2013 to create the report for my project. I added the BI-report-author group into the SQL Server 2012.
I configured and enabled the SSS already. But the problem still exist. So this is the solution from my discussion with Microsoft technician.
We create an account in SQL Server 2012, and modify the connection string in the ODC file of the Database connection of Sharepoint 2013.
So from now, every student can use the report and open it in Excel. When the excel program open the report file, it will use the information in the ODC file to connect to the SQL database and generates the report. So in this case, the credentials that exist in the ODC file will be display in plain text, and this solution brought another problem to myself.
So if anyone has a better solution to solve this double-hop problem, please sharepoint it me and i really appreciate for this.
I use the built-in excel report of sharepoint 2013 to create the report for my project. I added the BI-report-author group into the SQL Server 2012.
I configured and enabled the SSS already. But the problem still exist. So this is the solution from my discussion with Microsoft technician.
We create an account in SQL Server 2012, and modify the connection string in the ODC file of the Database connection of Sharepoint 2013.
So from now, every student can use the report and open it in Excel. When the excel program open the report file, it will use the information in the ODC file to connect to the SQL database and generates the report. So in this case, the credentials that exist in the ODC file will be display in plain text, and this solution brought another problem to myself.
So if anyone has a better solution to solve this double-hop problem, please sharepoint it me and i really appreciate for this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I understand this matter now. Please close this topic.
ASKER
I've requested that this question be deleted for the following reason:
i understand this problem now. please delete it.
i understand this problem now. please delete it.
a few questions and remarks to get down to the real issue, OK?
- Are you using the built-in Excel reports when you "create a new report"? Then you NEED to add the user account for the person designing the report as db_datareader to SQL Server
- Or another reporting tool?
- Do you want to make these reports (Excel) available to your team members via Excel Services? Have you setup and configures Secured Store Service (SSS) for that?
Regards
Thomas