Share
Report
670HI,
I recently performed an upgrade/migration of GP. Everything seemed fine. Then we found that client connections to SSRS and Excel reports did not function off of the SQL server. I was able to correct the SSRS connections by modifying the company connections in SSRS easily but, for Excel, all of the ODC files must be corrected with a string that includes the domain name. There are 13 companies.
Redeploying reports does not fix the issue because the ODC files seem to use the SQL server instance name but, don't included the domain name.
I thought I could address the issue by adding host records in the HOSTS file but that didn't work.
If I manually correct the ODC file, most reports test will function either immediately or by allowing the Excel file to reference the connection in the ODC file depending on how the Excel report was created.
Is there an easy way to change the ODC files? It seems like an application bug to me.
I have been researching PowerShell but, that isn't my forte. the thought of manually correcting 2,942 files is unpleasant.
If I change the Source, it works
From Source=server_name\MSSQLSERVER2019
To Source=server_name.domain.name\MSSQLSERVER2019
I also noted that post failure, if I try to correct the connection, the SQL Server Query connect GUI truncates the source string so, for the key reports in each company, the users can't self help. But that is not a GP BUG.
All responses (
Answers (
