I think it's a problem in SSMS. Because I just tried it in Azure Data Studio and it's no problem.

I work with SQL Server 2019 and the compatability level is 150

No thats not the casr. A full backup has been made firdst.

The first isn't working. I use this report for export to Word and I get 4 columns on the page.

I've tried your second option. I added your code as an...

Like stated in my case above, SQL Browser service is started, and there are inbound rules in the firewall for the ports

No, but that is not necessary for connection, is it?

Thanks Gianluca. It worked. I had to add another account since the link with the original account had become corrupt. But with the new account I removed the first and...

Oh, and I executed these statements

EXEC sp_fulltext_service 'update_languages';

EXEC sp_fulltext_service 'load_os_resources', 1;

EXEC sp_fulltext_service 'restart_all_fdhosts';

Exec sp_fulltext_service 'verify_signature', 0

SELECT document_type, path from sys.fulltext_document_types where document_type = '.pdf'

Hi Steve. Thanks for your answer. The things you mentioned I already did. I followed the instructions in the link (again). But without result.

- I uninstalled the PDF filter

- Deleted...

It shouldn't be the dynamic data source. I have 5 reports with a dynamic data source deployed on two different server with no problems (so far).

Did you, on the Report Server, go to the properties of the report, Data Sources. On the section Connect Using I gave the credentials for Credentials stored securely in the...

I found out that the parameters for the server name and database name, should be the first in the list with report parameters.

Did you ever get an answer, or did you find a solution yourself? Cause I have the same problem. Though I'm not working with a large dataset.