on 2017 Dec 27 10:06 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.