Question

can't make datasource in forms 10

Forms

Updated November 10, 2020

asked on December 11, 2016

Hello All

i am tried to make a data source in forms 10 but i am getting this error "An error occurred while testing the data source connection. See the Windows Event Log for details. [LFF2400-DataSourceConnectionError]"

our forms on server and database ( sql server express 2008 R2 ) in another server

below is the event log

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: An error occurred while testing the data source connection. See the Windows Event Log for details. [LFF2400-DataSourceConnectionError]
at E_Forms.Controllers.AuthorizationController.TestDatasource(Int32 dbType, String server, String db, String user, String password, Int32 dbId)
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.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(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)

Inner exception: System.Data.SqlClient.SqlException
Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at Laserfiche.Forms.EntityModels.Data.MSSqlDBConnector.TestConnect()
at E_Forms.Models.ViewModels.DataSource.TestDatasource(Int32 dbId, Int32 dbType, String server, String db, String user, String password)
at E_Forms.Controllers.AuthorizationController.TestDatasource(Int32 dbType, String server, String db, String user, String password, Int32 dbId)

0 0

Replies

replied on December 13, 2016

Hi Kareem,

There are a few things you can check:

Via SQL Management Studio, right-click the server, select Properties, and ensure that under the Connections section "Allow remote connections" is enabled.
Via SQL Server Config Manager, under the network config settings, ensure that TCP/IP is enabled.
Make sure your firewall settings allow for connectivity on port 1433 (unless you've changed the default port for SQL connections).
Make sure the SQL Browser service is automatic and running
Finally, make sure you are using the correct server name for your SQL server connection, usually in the format "sqlservername\instance". You can double-check on the naming via Mgt Studio.

Hopefully that sorts it for you.

Cheers,

Mike

1 0

replied on November 10, 2020

I know the original post is almost 4 years old, but I wanted to respond, confirming that a combination of #3 and #5 pointed us in the right direction, allowing us to use the lookup feature in our external Forms Portal (DMZ) forms. We had been getting the LFF2400 error message when attempting to set up a datasource. We ended up including the port in our Server name (in the Forms Configuration application on the DMZ server):

Example:

SERVERNAME,1433\SQLXXXX

Thanks to JG in our IT Dept and Zed from MCCI for helping get this resolved.

Hope this helps someone else too.

Christine

2 0

replied on December 12, 2016

Please make sure the SQL server is remote accessible. Have you ever tried that if you can connect to the SQL server from any machine not the one installed the SQL server?

0 0

You are not allowed to follow up in this post.

Question

Question

can't make datasource in forms 10

Replies

Sign in to reply to this post.