Login failed for user 'sa'.
When i deploy the process using Bizagi studio im getting the below error. the sql server user passowrd for sa is honey999, but still im getting hte below error. appreciate your help on this.
Server Error in '/BizagiProject1' Application.
Login failed for user 'sa'.
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.Data.SqlClient.SqlException: Login failed for user 'sa'.
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Below is the event Log Warning
-------------------------------------------------------------------------------------------------------------------------------------------------------------
- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="ASP.NET 4.0.30319.0" />
<EventID Qualifiers="32768">1309</EventID>
<Level>3</Level>
<Task>3</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2019-05-11T19:46:51.785117200Z" />
<EventRecordID>27973</EventRecordID>
<Channel>Application</Channel>
<Computer>DESKTOP-SBJCM2U</Computer>
<Security />
</System>
- <EventData>
<Data>3005</Data>
<Data>An unhandled exception has occurred.</Data>
<Data>5/11/2019 11:46:51 PM</Data>
<Data>5/11/2019 7:46:51 PM</Data>
<Data>2b9d1a4779314f8fad98c100ce6d7246</Data>
<Data>2</Data>
<Data>1</Data>
<Data>0</Data>
<Data>/LM/W3SVC/2/ROOT/BizagiProject1-59-132020776076893378</Data>
<Data>Full</Data>
<Data>/BizagiProject1</Data>
<Data>C:\Bizagi\Projects\BizagiProject1\WebApplication\</Data>
<Data>DESKTOP-SBJCM2U</Data>
<Data />
<Data>13364</Data>
<Data>iisexpress.exe</Data>
<Data>DESKTOP-SBJCM2U\HP</Data>
<Data>HttpException</Data>
<Data>Login failed for user 'sa'. at System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) at System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) at System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) at System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) at System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) Login failed for user 'sa'. at Bizagi.DA.CSqlDataProvider.RunQuery(String sQuery, String sTableName, Boolean bFillSchema, DataSet oDs, TableParameter[] tableParameters) at Bizagi.DA.CSqlDataProvider.RunQuery(String sQuery, String sTableName) at BizAgi.Defs.BAEnvironment.DA.BusinessEnvironmentDA.GetCurrentEnvironment() at BizAgi.Defs.BAEnvironment.BusinessEnvironmentService.GetCurrentEnvironment() at BizAgi.Util.Catalog.CatalogHelper.EnableCatalog3() at BizAgi.UI.WFBiz.CGlobalAsax.Application_Start(Object sender, EventArgs e) at BizAgiBPM.Global.Application_Start(Object sender, EventArgs e) Login failed for user 'sa'. at Bizagi.DA.HighAvailability.Retry.RetryDA.<>c__DisplayClass3_0.<Execute>b__0(Action action) at Bizagi.DA.CSqlDataProvider.Connect(CCachedConnection`2& oCachedConnection) at Bizagi.DA.CSqlDataProvider.RunQuery(String sQuery, String sTableName, Boolean bFillSchema, DataSet oDs, TableParameter[] tableParameters)</Data>
<Data>http://localhost:10024/BizagiProject1/WebServices/Cache.asmx</Data>
<Data>/BizagiProject1/WebServices/Cache.asmx</Data>
<Data>::1</Data>
<Data />
<Data>False</Data>
<Data />
<Data>DESKTOP-SBJCM2U\HP</Data>
<Data>40</Data>
<Data>DESKTOP-SBJCM2U\HP</Data>
<Data>False</Data>
<Data>at System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) at System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) at System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) at System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) at System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext)</Data>
</EventData>
</Event>
Dear Sai,
To resolve this issue, you need to install your IIS correctly following this article: https://help.bizagi.com/bpm-suite/en/11.2.2/index.html?prerequisites_iis.htm. After this, you need to change de web server from IIS Express to IIS.
Best Regards
Comments have been locked on this page!