It is quite normal if you are experiencing issues when deploying Crystal Report on a server. Based on the error message you experienced, it seems that you have not properly setup/configured your Crystal Report on the PC/server:
1. If you see this error message: "Type 'CrystalDecisions.Shared.CrystalReportsException' in assembly 'CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' is not marked as serializable", this is due to the fact
that your PC is unable to find the right Crystal Report version on your PC. Please try to UNINSTALL any previous Crystal Report version that you have on your system and then, please install Crystal Report for VS 2010 there. You can go tohttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_64bit_13_0_1.zip
(for 64 bit machine) ORhttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_1.zip (for 32 bit machine) ORhttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_1.exe (FULL package)
2. Once you have the CR installed on your system, please make sure you set your Crystal Report to operate on LOCAL SERVICE permission. Please check your application pool and make sure it runs under this permission
3. Please make sure the FULL TRUST read and write permission is set on your working folder
4. Please make sure you copy the CR aspnet_client folder to your working folder
Once you have done all the steps above, your crystal report 2010 should work fine. If you are still experiencing problems with your host, I would truly recommend you to migrate your service to
asphostcentral.com. This host has supported Crystal Report for VS 2010 and any earlier Crystal Report version.
If this post helps you, please mark it as an answer. Good luck!
P.S: Please always make sure you have one Crystal Report version running on your own server. If you have multiple different CR version, your report will not work!
We were getting this error too: "Failed to open the connection. Details: Database Vendor Code: 17" when we ran reports using the CRW viewer in a ASP.NET 4.0 based app (vs.net 2010) against SQL Server 2008.
But, we didn't get it on workstations in our LAN, only when we rolled out to a hosted cloud server running ASP.NET, IIS7, SQL2008.
After much searching around and trying many different things, we finally found that it was caused by the fact that the TCP/IP protocol was disabled for the SQL Server box (possibly the default configuration of this hosted SQL Server install). Our internal
development SQL Server's have this enabled by default.
To enable, use SQL Server Configuration Manager to enable TCPIP protocol (click Start, navigate to SQL Server 2008 R2, Configuration Tools, SQL Server Configuration Manager). Open SQL Server Network Configuration, open Protocols for
<servname> then enable TCPIP. close everything and restart SQL server using SSMS by right clicking the root note and hitting restart.
I hope this saves someone else a few hours of troubleshooting.
nicklibee
Member
650 Points
683 Posts
cr not working in server - windows server 2008
May 21, 2012 11:36 AM|LINK
Dear all,
After finishing the development , i have moved my application to test server.
The funniest part is the crystal report is not working in server but its working absolutely fine in my development pc.
The server is configured correct as there are many crystal report applciations working.
pls help me
thanks
nick
Mudasir.Khan
All-Star
15346 Points
3142 Posts
Re: cr not working in server - windows server 2008
May 21, 2012 12:00 PM|LINK
is the Database ConnectionString configured properly ?
nicklibee
Member
650 Points
683 Posts
Re: cr not working in server - windows server 2008
May 21, 2012 12:04 PM|LINK
yes, it is configured correctly
cnranasinghe
Star
8885 Points
1798 Posts
Re: cr not working in server - windows server 2008
May 24, 2012 08:17 AM|LINK
Check the CR version and download & install the correct runtime on the server.
zadzich
Member
2 Points
1 Post
Re: cr not working in server - windows server 2008
May 24, 2012 10:02 AM|LINK
Hi,
I'm new on forum and I have similar problem with Crystal Report.
vb.net2010, crystal version 13.0.2000.0
1. In my development works fine. ( On Pc with Win7proff 32bit.)
2. Installation is on pc win7home 64bit (Exe, sql 2005 Express database engin, database)
3. On Client Pc program works fine.
4. Empty report (with no data connection on it) works fine (testing loading report)
5. Report with data connection and dynamically binding data couse program crash .
6. Report with data on it without binding couse error
Failed to open the connection. Details: Database Vendor Code: 17
It looks like that error is on code where I bind data to report:
ReportDocument.Database.Tables(0).SetDataSource(dsRj.Tables(0))
necro_mancer
Star
8089 Points
1590 Posts
Re: cr not working in server - windows server 2008
May 25, 2012 03:44 AM|LINK
hi there,
It is quite normal if you are experiencing issues when deploying Crystal Report on a server. Based on the error message you experienced, it seems that you have not properly setup/configured your Crystal Report on the PC/server:
1. If you see this error message: "Type 'CrystalDecisions.Shared.CrystalReportsException' in assembly 'CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' is not marked as serializable", this is due to the fact that your PC is unable to find the right Crystal Report version on your PC. Please try to UNINSTALL any previous Crystal Report version that you have on your system and then, please install Crystal Report for VS 2010 there. You can go tohttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_64bit_13_0_1.zip (for 64 bit machine) ORhttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_1.zip (for 32 bit machine) ORhttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_1.exe (FULL package)
2. Once you have the CR installed on your system, please make sure you set your Crystal Report to operate on LOCAL SERVICE permission. Please check your application pool and make sure it runs under this permission
3. Please make sure the FULL TRUST read and write permission is set on your working folder
4. Please make sure you copy the CR aspnet_client folder to your working folder
Once you have done all the steps above, your crystal report 2010 should work fine. If you are still experiencing problems with your host, I would truly recommend you to migrate your service to asphostcentral.com. This host has supported Crystal Report for VS 2010 and any earlier Crystal Report version.
If this post helps you, please mark it as an answer. Good luck!
P.S: Please always make sure you have one Crystal Report version running on your own server. If you have multiple different CR version, your report will not work!
Professional SQL 2008 R2 Service
jeffreymergl...
Member
110 Points
31 Posts
Re: cr not working in server - windows server 2008
Dec 10, 2012 07:50 PM|LINK
We were getting this error too: "Failed to open the connection. Details: Database Vendor Code: 17" when we ran reports using the CRW viewer in a ASP.NET 4.0 based app (vs.net 2010) against SQL Server 2008.
But, we didn't get it on workstations in our LAN, only when we rolled out to a hosted cloud server running ASP.NET, IIS7, SQL2008.
After much searching around and trying many different things, we finally found that it was caused by the fact that the TCP/IP protocol was disabled for the SQL Server box (possibly the default configuration of this hosted SQL Server install). Our internal development SQL Server's have this enabled by default.
To enable, use SQL Server Configuration Manager to enable TCPIP protocol (click Start, navigate to SQL Server 2008 R2, Configuration Tools, SQL Server Configuration Manager). Open SQL Server Network Configuration, open Protocols for <servname> then enable TCPIP. close everything and restart SQL server using SSMS by right clicking the root note and hitting restart.
I hope this saves someone else a few hours of troubleshooting.