Lucee 6.0.0.585 Error (java.io.IOException)
Message com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SSMWebUser2'. ClientConnectionId:5d879d09-688d-4e3e-bead-e3bfd3554ee9
Stacktrace The Error Occurred in
C:\inetpub\wwwroot\edclick\Improve1.cfm: line 36
34: <cfquery name="RSCtry" datasource="SSMDBAzure" username="SSMWebUser2" password="Flerk610**23">
35: SELECT TOP 1 Ctry FROM IpToCountry WHERE #num# BETWEEN ipfrom and ipto
36: </cfquery>
37: <cfif RSCtry.RecordCount NEQ 0>
38: <cfreturn RSCtry.Ctry>

called from C:\inetpub\wwwroot\edclick\Improve1.cfm: line 47
Java Stacktrace lucee.runtime.exp.NativeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SSMWebUser2'. ClientConnectionId:5d879d09-688d-4e3e-bead-e3bfd3554ee9
  at lucee.runtime.db.DatasourceConnectionFactory.create(DatasourceConnectionFactory.java:61)
  at lucee.runtime.db.DatasourceConnectionFactory.create(DatasourceConnectionFactory.java:21)
  at org.apache.commons.pool2.BasePooledObjectFactory.makeObject(BasePooledObjectFactory.java:58)
  at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918)
  at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431)
  at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356)
  at lucee.runtime.config.DatasourceConnPool.borrowObject(DatasourceConnPool.java:30)
  at lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerImpl.java:79)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1119)
  at lucee.runtime.tag.Query._doEndTag(Query.java:701)
  at lucee.runtime.tag.Query.doEndTag(Query.java:566)
  at improve1_cfm$cf$as.udfCall(/Improve1.cfm:36)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
  at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:787)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1777)
  at improve1_cfm$cf$as.call(/Improve1.cfm:47)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:65)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2480)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2451)
  at lucee.runtime.engine.Request.exe(Request.java:45)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1219)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1165)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:424)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
  at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.base/java.lang.Thread.run(Thread.java:829)
 Caused by: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SSMWebUser2'. ClientConnectionId:5d879d09-688d-4e3e-bead-e3bfd3554ee9
  ... 53 more
 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SSMWebUser2'. ClientConnectionId:5d879d09-688d-4e3e-bead-e3bfd3554ee9
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
  at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:305)
  at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:138)
  at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:6490)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:5068)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:93)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:5002)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3487)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3077)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2919)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1787)
  at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1229)
  at lucee.runtime.db.DataSourceSupport._getConnection(DataSourceSupport.java:145)
  at lucee.runtime.db.DataSourceSupport.getConnection(DataSourceSupport.java:109)
  at lucee.runtime.db.DatasourceConnectionFactory.create(DatasourceConnectionFactory.java:58)
  ... 52 more
 
Timestamp 3/29/24 5:39:08 AM CDT