Vendor database code 18

[Former Member]

We have an application that is developed in ASP.net 3.5 version, recently we upgraded the web server from window 2008 to windows 2008 R2, we have SQL server 2008 R2 on the database side. After that upgrade, we are getting the logon failed issue, when we try to generate reports.Below is the error message :

Logon failed

Details: [Database Vendor Code : 18]

Unable to connect: Incorrect Logon parameters

Below is the Server Configuration :

Web Server: MS Windows 2008 R2

.NET Framework: 3.5

Crystal Report: Version 12.2...290 , run time 2008 SP3

TLS: 1.2

DB Server: SQL 2008 R2 with TLS1.2

DB login information is same after the OS update.

[former_member11696 · Accepted solution]

You need to get to Crystal Reports 2008 SP 7 which you can from here:

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/patch_download/main_public.htm

Use Google and search for this KBA:

Disabling TLS 1.0 may cause Crystal Reports Designer and .NET application to fail to connect to your MS SQL Server Database 2012/2014

Create the MS registry keys to disable TLS 1.0 and 1.1 and enable 1.2

Also, to update to the latest CR .NET using VS 2010 -> 2017 you need to use this .NET package:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

As of CR 2011 all CR runtime is now from the above link, no longer shipped or installed with CR Designer.

Don