Database Vendor Code: 18

[famojuroa]

We are having problems generating CR from one of our application. The reports were generating until Wednesday 31Oct18.

TLS 1.0 was disabled on all the environments and the environment is DB MS OS 2016, SQL 2014. Crystal report is not installed on the DB and AP servers but the crystal report version on the client is 2011.

Here is the error :

System.Runtime.InteropServices.COMException (0x8004100F): Logon failed. Details: [Database Vendor Code: 18 ] Error in File <report type>.rpt: Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: 18 ] at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)

You insight and assistance will be greatly appreciated. Let me know if you have any questions.

[former_member11696 · Accepted solution]

The issue is likely due to some info in this KBA:

https://apps.support.sap.com/sap/support/knowledge/public/en/2269180

You MUST use an updated version of CR that supports MS's SQL Native 11 client and enable TLS 1.2, disable TLS 1.0/1.1 and update the reports to use the SQL Native 11 client as well.

Once you use a version of CR Products that support SQL Native 11 client and apply all of the MS patches in the KBase it should work.

The error is generated by MS, not CR, we just assume the client is configured properly.

Don

[DellSC]

A "database vendor code" error is an error that is passed through from the database - it doesn't originate in Crystal itself.

A quick Google search of "SQL Server error 18" brought up this link that may provide information to help you. https://stackoverflow.com/questions/29637713/unable-to-connect-to-sql-server-2008-using-odbc-connect...

-Dell