I am trying to install the Reporting tools on a secondary computer and the server DB is MS SQL2008. After the Reporting tools installation I am prompted to enter the SQL server and DB information prior to starting the Reporting tool. Upon entering all of the proper information the DB connection fails due to:
Unexpected error occured in PAData:minsOpenConnection[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I am using Windows auth only, rather than mixed mode but don't see where that would cause an issue as the server connects just fine to the DB. This is only occuring when admin or reporting tools are installed on clients.