on 09-17-2014 5:29 PM
I have converted a ASP.NET 1.0 app to 4.0. It is a simple app with only 3 pages and 4 reports. For the most part the conversion went well and on both my development machine and the production machine I can run it, navigate between the pages, retrieve and update data from a SQL Server 2008 R2 database. On the development machine I can also create Crystal Reports which are then exported to PDF. On the production machine however when I try to do this I get this message:
Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code.
Exception Details:
System.Runtime.InteropServices.COMException: Database logon
failed.
Source Error:
An unhandled exception was generated during the execution of the |
Stack Trace:
|
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET
Version:4.0.30319.34209
On my development machine:
Windows 7
IIS 7
Visual Studio 2010
Crystal Reports for Visual Studio 2010
The reports had been developed in Crystal XI but they were imported in to VS 2010 converted and saved
The app runs under a application pool I created that uses a network Windows account that has all the necessary permission on the SQL Server objects.
In the web.config file identity impersonate is set to true.
On the production machine:
Windows Server 2012 R2
IIS 8
SAP Crystal Reports runtime engine for. NET Framework (64-bit) 13.0.10.1385
The app runs under a application pool I created that uses the same Windows account as on my development machine
In the web.config file identity impersonate is set to true.
IIS and application are on one server and SQL Server is on another. The server that IIS is on is named Intranet02 and the Intranet02$ account has all the necessary permissions on the database objects.
The pertinent code:
Dim crpt As New ReportDocument()
crpt = New rptCategory()
ReportName = "Category"
MakeCrParameter(txtStartDate.Text, "@StartDate", crpt)
MakeCrParameter(txtEndDate.Text, "@EndDate", crpt)
FileName = MakePDFfile(crpt, ReportName)
Private Function MakePDFfile(ByVal crpt As ReportDocument, ByVal ReportName As String) As String
Dim TodayFile As String = Month(Now) & Day(Now) & Year(Now)
Dim FileName As String = ReportName & " " & Now.Month & "-" & Now.Day & "-" & Now.Year & "-" & Now.Second & ".pdf"
Dim dfdo As New CrystalDecisions.Shared.DiskFileDestinationOptions()
dfdo.DiskFileName = "C:\WebApps\EslCalls\Reports\" & FileName
With crpt
ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile
.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat
.ExportOptions.DestinationOptions = dfdo
Export()
Close()
.Dispose()
End With
GC.Collect()
GC.WaitForPendingFinalizers()
MakePDFfile = FileName
'Open a new window linked to the PDF file containing the report. The window is resizable.
Dim Script As String = "<Script language='javascript'> win=window.open('/EslCalls/Reports/" + FileName + "','Reports','width=800,height=500,resizable=1')</script>"
Page.ClientScript.RegisterStartupScript(Me.GetType(), "Session Timed Out", Script, False)
'Clear the form after the report has been created
Clear() End Function
The error occurs at the line
Export()
Any suggestions would be greatly appreciated.
I have a report that doesn't connect to a database and it opens on the production machine. It seems like it must be a permissions issue but I don't know what it would be as the app should be running under the same account on both my development and my production machine and the reports open on my development machine.
I was thinking perhaps on the server the app was running under a different identity then I expected so I put Dim username As String = System.Security.Principal.WindowsIdentity.GetCurrent().Name Response.Write("User = " & username) right before the code that generates the report. On both the production and development machines it shows the correct user account.
Hi Les
Couple of things to check off:
If the connection is via ODBC, make sure you are using a 64 bit ODBC datasource.
This being MS SQL the following client installs are important:
MS SQL 2005 - OLE DB Provider
MS SQL 2008 - SQL Native 10
MS SQL 2012 - SQL Native 11
MS SQL 2013 - SQL Native 11
For ODBC then use:
MS SQL 2005 - SQL Native
MS SQL 2008 - SQL Native 10
MS SQL 2012 - SQL Native 11
MS SQL 2013 - SQL Native 11
Other than that, in your code I do not see any APIs for establishing a database connection(?).
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm trying to create a new Datasource Location for one of the reports hard coding in a User ID and password instead of using Integrated Security but when I click on Finish I get this message:
Login failed.
Details:ADO Error Code: 0x80040e4d
Source: Microsoft OLE DB Provider for SQL Server
Description:Login failed for user 'HRanon'.
SQL State: 42000
Native Error: 18456 [Database Vendor Code 18456]
This happens even if I use my user name and password which has administrative permissions on both server.
Hi Les
Integrated security works as it always has. The error "Database Vendor Code 18456" is coming directly from the database client so check the db documentation for details on that. Googling the error and quickly scanning some of the hits I still believe you do not have the correct client installed on that computer though...
- Ludek
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.