Our users utilize SSRS to get data now via Excel or CSV.  Just making sure we weren't missing some option to do JSON export in some fashion too.

Not sure if makes a difference, but just told by db/server admin this web service is setup for cookie authentication.

We got the report to work by changing our datasource connection string InStr() to uppercase for the first parameter, and the new server URL is uppercased.

Our expression works now after...

in place upgrade of everything

** Answer per our admin:

When you say you upgraded SQL Server - what exactly was upgraded?

--Everything was upgraded. SQL Server itself and SSRS. They are stand alone installations now so...

For the credentials, we have the datasource to use a specific username/pwd...see attached.