Connections Test fails connecting SQL Server DB but Report runs allright (DirectQuery/Rel. Aug.18)

[AndreasScholl]

Hey folks,

strange behavior on Report Server while connecting SQL Server DB by Direct Query mode.  [Release August 18]

While connection test within datasource menu of the Report Server fails the report itself is running allright.

Can anybody reproduce that as well and may let me know why that occurs...

Thanks

Andreas

[jcollinson2001]

Hi Andreas,

Sounds like the same issue reported here?

https://community.powerbi.com/t5/Report-Server/Test-Connection-Broken/m-p/405157

Thanks,

John

[AndreasScholl]

Hi John,

it does.

Thank you, but unfortunately the August 18 release does not solve the problem for me, unlike others posting in the mentioned thread....

Andreas

[jcollinson2001]

Hi Andreas,

Ahh - sorry to hear it did not solve the issue. Long shot, but clearing your web browser cache doesn't solve the issue?

(outdated browser cache has caused all sorts of issues following our upgrade to August 2018)

John

[AndreasScholl]

Hi John,

tried it - still the same behavior....

Andreas