Skip to Content
avatar image
Former Member

Vendor database code 18

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 11 at 03:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded