You are viewing limited content. For full access, please sign in.

Question

Question

Laserfiche Forms 9.2 not asking to update the SQL Database.

asked on November 7, 2014

I tried to upgrade my Forms piece from 9.1 to 9.2 and I have had nothing but issues. I re-installed 9.2 Forms but now it will not ask me to update the SQL database per your 9.2 white paper.

The software sticks on "Checking Database" when I click save.

 

Here is what I get in the Windows application log.

11/7/2014 8:25:44 PM 
Message: ERROR [08004] [Microsoft][SQL Native Client][SQL Server]The server principal "IIS APPPOOL\FormsAppPool" is not able to access the database "Forms" under the current security context.
Stack trace:    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at FormsConfig.Util.DatabaseHelper.SchemaExists(OdbcConnection conn, String userName)
   at FormsConfig.Infrastructure.DatabaseInfo.GetDbStatus()
   at FormsConfig.Controllers.ConfigurationController.GetDbStatus(DatabaseInfo databaseInfo)
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass48.<InvokeActionMethodFilterAsynchronouslyRecursive>b__41()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)

 

 

0 0

Answer

APPROVED ANSWER
replied on November 7, 2014

Check the identity of your FormsAppPool and make sure it is using an account that has rights to the SQL database.

0 0

Replies

replied on November 9, 2014

You may choose "Use Windows Authentication" to connect the database, but the identity for the FormsAppPool has no right to connect the database, please refer to http://www.laserfiche.com/support/webhelp/laserficheforms/9.2/en-us/forms/#SystemSettings.htm#UsingWindowsAuthenticationwiththedatabaseserver for how to configure use Windows Authentication with the database server

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.