Estou tentando conectar uma aplicação no sql server, mas no momento de fazer o login, utilizando o context.xml, o tomcat apresenta o erro:
dez 30, 2015 8:58:12 PM org.apache.catalina.realm.JDBCRealm authenticate SEVERE: Exception performing authentication com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241) at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243) at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:702) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:350) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:281) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:453) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Houve a tentantiva de configurar a porta 1433, através do gerenciado do banco, no TCP/IP Properties, através do campo IPALL, mas sem sucesso.
Context.xml
<?xml version="1.0" encoding="UTF-8"?> <Context antiJARLocking="true" path="/tam"> <Realm className="org.apache.catalina.realm.JDBCRealm" connectionURL="jdbc:sqlserver://127.0.0.1:1433;databaseName=INVENTARIO_FISICO;user=workflow;password=@work123" digest="MD5" driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver" roleNameCol="perfil" userCredCol="senha" userNameCol="login" userRoleTable="dbo.pad_usuarios" userTable="dbo.pad_usuarios"/> </Context>
Obrigado pela ajuda.