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:
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.