Sql Server Login Prompt for Console App

[pethmani]

I created new console app with sql server connection and report is not running from server and got popup message to entery login and password. can you please help me out .

Thanks in advance.

[pethmani]

Here is code

[pethmani]

getting login failed error passing correct user name and password and report is working good in locally when i run the report.

[gerardo-lijs]

Hi, what version of the library for runtime 13.0.34 are you using? I had some issues with some specific reports and made some changes in the source code but only published 13.0.20 runtime x86 Maybe it's that.

You could try to: a) compile the latest source code for 13.0.34 b) try an older version of 13.0.34 (like v1.3.3) c) try with 13.0.20 x86 v1.4.8 (you will need to installa another runtime for CR in your system).

If any of those 3 options work, I can publish v1.4.8 for runtime 13.0.34 and that will work for you. If it doesn't work, then you will need to double check connection parameters, what SQL OLEDB or datasource you are using, etc

[pethmani]

Thank you for quick response. I tried with 13.0.34 and 13.0.35 both giving same database logon failed issue. you said you had same issue in past do can you please update your source code and build new runtime version for 13.0.35 or 13.0.34.
If possible please build it for 64x since all server is running in 64x.
The sql connection information are good since report is working good locally if i ran the reports.

[gerardo-lijs]

The issue I was having was with one strange report and it was failing both in local and production. In youe case, if it works locally it might be something in the database connection/configuration. For example, it might require to have SQL OLE DB 19 installed in the server if you are using that datasource. https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16