SQL Server integration

0
What does this error mean? I am getting this error while connecting my SQL Server with mendix.   An error has occurred while handling the request. [User 'Anonymous_002739a3-fdb0-4273-8d44-7f71c15c8bfc' with session id '08c364db-XXXX-XXXX-XXXX-XXXXXXXX0db5' and roles 'Administrator'] -------- com.mendix.webui.WebUIException: Exception while retrieving data for list widget 'MyFirstModule.Course_Overview.listView5' on page 'MyFirstModule.Course_Overview'     at com.mendix.webui.actions.client.RetrieveByMicroflowAction.$anonfun$apply$2(RetrieveByMicroflowAction.scala:62) Caused by: com.mendix.core.CoreException: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MXadmin'. ClientConnectionId:b23be6dd-442d-49a8-99c7-03b07bf63c1e     at MyFirstModule.Course_Show (JavaAction : 'Execute query') Advanced stacktrace:     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:354) Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MXadmin'. ClientConnectionId:b23be6dd-442d-49a8-99c7-03b07bf63c1e     at MyFirstModule.Course_Show (JavaAction : 'Execute query') Advanced stacktrace:     at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:147) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MXadmin'. ClientConnectionId:b23be6dd-442d-49a8-99c7-03b07bf63c1e     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:386) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MXadmin'. ClientConnectionId:b23be6dd-442d-49a8-99c7-03b07bf63c1e     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:156) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MXadmin'. ClientConnectionId:b23be6dd-442d-49a8-99c7-03b07bf63c1e     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MXadmin'. ClientConnectionId:b23be6dd-442d-49a8-99c7-03b07bf63c1e     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254)     at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:258)     at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:104)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4772)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3581)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:81)     at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3541)     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2395)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120)     at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:700)     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)     at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:356)     at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)     at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)     at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)     at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)     at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)     at databaseconnector.impl.JdbcConnectionManager.getConnection(JdbcConnectionManager.java:50)     at databaseconnector.impl.JdbcConnector.executeQuery(JdbcConnector.java:96)     at databaseconnector.impl.JdbcConnector.executeQuery(JdbcConnector.java:85)     at databaseconnector.actions.ExecuteQuery.executeAction(ExecuteQuery.java:81)     at databaseconnector.actions.ExecuteQuery.executeAction(ExecuteQuery.java:58)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)     at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152)     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:382)     at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:53)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)     at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152)     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:348)     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:363)     at com.mendix.webui.actions.client.RetrieveByMicroflowAction.$anonfun$apply$2(RetrieveByMicroflowAction.scala:40)     at scala.util.Either.map(Either.scala:353)     at com.mendix.webui.actions.client.RetrieveByMicroflowAction.apply(RetrieveByMicroflowAction.scala:29)     at com.mendix.webui.actions.client.RetrieveByMicroflowAction.apply(RetrieveByMicroflowAction.scala:17)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$.$anonfun$liftEither$1(RegularClientAction.scala:29)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.$anonfun$apply$4(RegularClientAction.scala:55)     at com.mendix.webui.requesthandling.helpers.StateHandling.withState(StateHandling.scala:35)     at com.mendix.webui.requesthandling.helpers.StateHandling.withState$(StateHandling.scala:32)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.withState(RegularClientAction.scala:45)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:53)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:45)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$3(RegularClientAction.scala:109)     at scala.util.Try$.apply(Try.scala:213)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2(RegularClientAction.scala:109)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2$adapted(RegularClientAction.scala:107)     at com.mendix.webui.requesthandling.helpers.ContextHandling.$anonfun$inContext$5(ContextHandling.scala:47)     at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25)     at com.mendix.webui.requesthandling.helpers.ContextHandling$ClientMonitoredAction.monitor(ContextHandling.scala:59)     at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:47)     at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:27)     at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:86)     at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:24)     at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:19)     at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:86)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$1(RegularClientAction.scala:107)     at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)     at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest(ProfileHandling.scala:14)     at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest$(ProfileHandling.scala:10)     at com.mendix.webui.actions.client.RegularClientAction.profileRequest(RegularClientAction.scala:86)     at com.mendix.webui.actions.client.RegularClientAction.execute(RegularClientAction.scala:104)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:104)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:81)     at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:76)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:73)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:79)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:963)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.service(RuntimeHandler.java:42)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:867)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:542)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1588)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1557)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)     at org.eclipse.jetty.server.Server.handle(Server.java:502)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)     at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)     at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)     at java.base/java.lang.Thread.run(Thread.java:834)  The URL I have given is  jdbc:sqlserver://LENOVO:1433;databasename=ExternalDB;encrypt=true;trustServerCertificate=true;      
asked
1 answers
0

Hello,

In the error you have details:

 

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MXadmin'. ClientConnectionId:b23be6dd-442d-49a8-99c7-03b07bf63c1e

 

 

The error message indicates that there is a problem with the SQL Server login for user 'MXadmin' and that the login attempt has failed. The error message also provides some additional information such as the client connection ID that may be helpful in troubleshooting the issue.

It's possible that the SQL Server credentials used to connect to the server may be incorrect or the user may not have the necessary permissions to access the database or tables. It could also be an issue with the network connectivity or the SQL Server instance itself.

To resolve this error, you may need to check the SQL Server configuration, double-check the login credentials, verify network connectivity, and ensure that the user has the necessary permissions to access the required database and tables.

 

Regards

answered