<RESOLVIDO>Problemas de conexão com sql server 2012 pelo tomcat

abaixo o erro que dá ao start o tomcat:

jan 15, 2018 10:27:44 AM org.apache.catalina.core.StandardEngine startInternal

INFORMAÇÕES: Starting Servlet Engine: Apache Tomcat/7.0.82

jan 15, 2018 10:27:45 AM org.apache.catalina.loader.WebappClassLoaderBase validateJarFile

INFORMAÇÕES: validateJarFile(C:\ambiente\servers\apache-tomcat-7.0.82\webapps\projeto_piloto\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class

jan 15, 2018 10:28:00 AM org.apache.catalina.realm.JDBCRealm startInternal

GRAVE: Exception opening database connection

com.microsoft.sqlserver.jdbc.SQLServerException: Falha na conexão TCP/IP com o host ilusoes2012, porta 1433. Erro: “ilusoes2012. Verifique as propriedades da conexão. Verifique se uma instância do SQL Server está sendo executada no host e se está aceitando conexões TCP/IP na porta. Verifique se as conexões TCP na porta não foram bloqueadas por um firewall.”.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)

at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)

at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369)

at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:551)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1963)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)

at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:714)

at org.apache.catalina.realm.JDBCRealm.startInternal(JDBCRealm.java:792)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5513)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1700)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1690)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

jan 15, 2018 10:28:05 AM org.apache.catalina.startup.TldConfig execute

INFORMAÇÕES: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

log4j:WARN No such property [target] in biz.minaret.log4j.DatedFileAppender.

log4j:WARN No such property [datePattern] in biz.minaret.log4j.DatedFileAppender.

jan 15, 2018 10:28:05 AM org.apache.catalina.core.ApplicationContext log

INFORMAÇÕES: Initializing Spring root WebApplicationContext

[WARN ][2018-01-15 10:28:08][localhost-startStop-1] (JDBCExceptionReporter.java->logExceptions:100) - SQL Error: 0, SQLState: null

[ERROR][2018-01-15 10:28:08][localhost-startStop-1] (JDBCExceptionReporter.java->logExceptions:101) - Cannot create PoolableConnectionFactory (Falha de logon do usuário ‘sa’. ClientConnectionId:118f9255-2e7c-49c3-b364-7020d5c4373d)

[WARN ][2018-01-15 10:28:08][localhost-startStop-1] (SettingsFactory.java->buildSettings:137) - Could not obtain connection to query metadata

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Falha de logon do usuário ‘sa’. ClientConnectionId:118f9255-2e7c-49c3-b364-7020d5c4373d)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)

at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)

at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)

at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:563)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5110)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5633)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1700)

at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1690)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Falha de logon do usuário ‘sa’. ClientConnectionId:118f9255-2e7c-49c3-b364-7020d5c4373d

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)

at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:279)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:99)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4346)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3160)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3123)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1981)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)

at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

… 34 more

jan 15, 2018 10:28:11 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deploying web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\docs

jan 15, 2018 10:28:11 AM org.apache.catalina.startup.TldConfig execute

INFORMAÇÕES: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

jan 15, 2018 10:28:11 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deployment of web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\docs has finished in 322 ms

jan 15, 2018 10:28:11 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deploying web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\examples

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.TldConfig execute

INFORMAÇÕES: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

jan 15, 2018 10:28:12 AM org.apache.catalina.core.ApplicationContext log

INFORMAÇÕES: ContextListener: contextInitialized()

jan 15, 2018 10:28:12 AM org.apache.catalina.core.ApplicationContext log

INFORMAÇÕES: SessionListener: contextInitialized()

jan 15, 2018 10:28:12 AM org.apache.catalina.core.ApplicationContext log

INFORMAÇÕES: ContextListener: attributeAdded(‘org.apache.jasper.compiler.TldLocationsCache’, ‘org.apache.jasper.compiler.TldLocationsCache@127b1c03’)

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deployment of web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\examples has finished in 702 ms

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deploying web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\host-manager

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.TldConfig execute

INFORMAÇÕES: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deployment of web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\host-manager has finished in 327 ms

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deploying web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\manager

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.TldConfig execute

INFORMAÇÕES: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deployment of web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\manager has finished in 312 ms

jan 15, 2018 10:28:12 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deploying web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\ROOT

jan 15, 2018 10:28:13 AM org.apache.catalina.startup.TldConfig execute

INFORMAÇÕES: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

jan 15, 2018 10:28:13 AM org.apache.catalina.startup.HostConfig deployDirectory

INFORMAÇÕES: Deployment of web application directory C:\ambiente\servers\apache-tomcat-7.0.82\webapps\ROOT has finished in 379 ms

jan 15, 2018 10:28:13 AM org.apache.coyote.AbstractProtocol start

INFORMAÇÕES: Starting ProtocolHandler [“http-bio-8080”]

jan 15, 2018 10:28:13 AM org.apache.coyote.AbstractProtocol start

INFORMAÇÕES: Starting ProtocolHandler [“ajp-bio-8009”]

jan 15, 2018 10:28:13 AM org.apache.catalina.startup.Catalina start

INFORMAÇÕES: Server startup in 28373 ms