in the Fressh Machine CRRuntime_64bit_13_0_22 fails to retrive data from remote Sql Server 2019

[rajKT]

in the Fressh Machine
CRRuntime_64bit_13_0_22 fails to retrive data from remote Sql Server 2019. 

[rajKT]

SAP Should provide answer . in the Fressh Machine CRRuntime_64bit_13_0_22 fails to retrive data from remote Sql Server 2019

[DonWilliams]

Refer to the supported Platforms page:

https://www.sap.com/documents/2016/06/f871031e-757c-0010-82c7-eda71af511fa.html

SQL Server 2019 is not supported until SP 27, you are using SP 22.

Upgrade your projects runtime, and no you can't just install SP 27, developer must rebuild the application.

[rajKT]

i have install new vs 2019 and there i move my project and instal crystal report vs for 2019 and build the project . now i run that project in clinet machine and install runtime 28 (because i have also add 28 in developmet machine) i still got same issue. i have open each reort in new 2019 machine . even same issue 😞

[rajKT]

even i ty to connect database using balnk crystal report i got this error secdoClientHandshake());ssl security error . SQL state 08001 native error 18

[DonWilliams]

That error is generated by MS SQL Server, try search for fixes for that error:

https://learn.microsoft.com/en-us/answers/questions/1320162/how-to-fix-error-microsoft-odbc-driver-1...

Use SP 36, CR for VS only supports the latest release. It will have all of the latest Security patches.

It could be you are using MS SQL Server with TLS 1.2 enabled in which case you must update each report manually and use ODBC or OLE DB.

I use ODBC for testing, if your security is set up correctly when you test the connection it should work, if it works in ODBC then update each report to use the New DSN and then refresh and save the report, it should work now.

PS - you can't update the original report in code to support TLS 1.2, CR keeps the DB client info in the RPT file and only way to update it is to use CR Designer to update the client info.

See this KBA for more info:

2269180 - Disabling TLS 1.0 and 1.1 causes Crystal Reports and .NET application to fail to connect t...

[rajKT]

As my SQl 2019 server is running in Ubuntu server .  i have modify 

[ system_default_sect ] MinProtocol = TLSv1.2 CipherString = DEFAULT@SECLEVEL=2

in the server . but nothing is happen. same issue and same problem

1. install cr 29 developer version in  visual studion 2017 and buitl the project

2. install cr 29 runtime in client machine

3. Microsoft ODBC Driver 18 for SQL Server  install in client machine.

so hoping to get right answer from the commnity

[DonWilliams]

CR is simply passing the error to you, it's not being generated by Crystal so you'll have to contact Microsoft for a solution. Try this: https://bobcares.com/blog/sql-server-error-18/

Does the ODBC Test connection work?

[rajKT]

If i post in sql server community then there is message that cr have answer now if i post in cr then they say sql server have answert .God i dont konw who have the answer

[DonWilliams]

Use the latest SP 36 and try again. As I said CR is simply passing the error message from the Client to you so nothing CR can do to fix that error.

[MarineMazoyer]

Hi RajKT

This being a technical issue I would highly recommend contacting Technical support and open a service request.  Alternatively I would suggest as it is related to SQL server you may also add to your question above in the 'managed tag' field the following so that your questions is posted within the area of :   #Microsoft SQL Server

Best, Marine

[rajKT]

ok i have again post in that group let's see .