Precision, Performance, Confidence. ™

Database logon failed error when running Reports in MET/TEAM

Symptom:  

MET/TEAM is installed, configured and working correctly, however errors occur whenever the user attempts to run a report.  When this is attempted in a browser on the server itself, the error will look similar to the message at the bottom of this article.  

Solution:

If the installation used MSSQL Server 2012 (or later) the problem is most likely that the SQL Server Native client 10 was not installed on the server.  This is installed with SQL 2008R2 but not later versions.  This file can be downloaded for free from the Microsoft Web site. The name is "Microsoft® SQL Server® 2008 R2 Native Client" and is part of the "SQL Server® 2008 R2 Feature Pack".  The actual file to install is "sqlncli.msi" and there are OS specific versions of this file so pay particular attention to ensure the correct one is selected..

  

Error displayed in the browser on the server...

Server Error in '/' Application.

--------

Database logon failed.

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 current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

 

[COMException (0x8004100f): Database logon failed.]

   CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) +0

   CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +263

 

[LogOnException: Database logon failed.]

   CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) +334

   CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +318

   CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) +663

   CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) +97

   CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) +85

   MetTeamShared.CrystalWrapper.Render() +45

   orx.Helpers.CrystalHelper.ReportToBytes(IReportDocument doc, Dictionary`2 parameters) +293

   orx.Helpers.CrystalHelper.RenderToOutputStream(HttpResponse response, IReportDocument document, Boolean asAttachment) +45

   orx.Controllers.CrystalController.RenderReport(String id, Dictionary`2 parameters, String outputName, Boolean asAttachment) +710

   lambda_method(Closure , ControllerBase , Object[] ) +264

   System.Web.Mvc.<>c__DisplayClass1.<WrapVoidAction>b__0(ControllerBase controller, Object[] parameters) +17

   System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17

   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +205

   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27

   System.Web.Mvc.Async.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() +28

   System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12

   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57

   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +50

   System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +58

   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +237

   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +237

   System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +12

   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57

   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +50

   System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +24

   System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +126

   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57

   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +45

   System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +14

   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25

   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62

   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +61

   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25

   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62

   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +49

   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10

   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +28

   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25

   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62

   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +49

   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9

   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9048781

   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +184

--------

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1031

 

Have more questions? Submit a request

Comments

Please sign in to leave a comment.