com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host SERVER1, port 1433 has failed. Error: "null. 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.".

Stack Overflow | user3321551 | 4 months ago
  1. 0

    Why am I getting a "SQLServerException: The TCP/IP connection to the host [...], port 1433 has failed"?

    Stack Overflow | 4 months ago | user3321551
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host SERVER1, port 1433 has failed. Error: "null. 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.".
  2. 0

    SpringXD 1.1.0- JDBC source connection issues with SQL SERVER

    Stack Overflow | 2 years ago
    org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The port number 1433/Databasename is not valid.
  3. 0

    Database connection issue after moving from tomcat-dbcp to tomcat-jdbc connection pooling - www.scriptscoop2.com

    scriptscoop2.com | 6 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'testuser'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java y Sql Server

    el-hacker.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: No se pudo realizar la conexión TCP/IP al host (aqui muestra mi servidor o mi ip), puerto 1433. Error: "Connection refused: connect. Verifique las propiedades de conexión, compruebe que hay una instancia de SQL Server ejecutándose en el host y aceptando las conexiones TCP/IP en el puerto y compruebe que no hay ningún firewall bloqueando las conexiones TCP en el puerto.".
  6. 0

    SQL Server jdbc connection

    Stack Overflow | 4 years ago | yatinbc
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, 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.".
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    The TCP/IP connection to the host SERVER1, port 1433 has failed. Error: "null. 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()
  2. com.microsoft.sqlserver
    SQLServerDriver.connect
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)[sqljdbc4-4.0.jar:na]
    2. com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)[sqljdbc4-4.0.jar:na]
    3. com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)[sqljdbc4-4.0.jar:na]
    4. com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)[sqljdbc4-4.0.jar:na]
    5. com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)[sqljdbc4-4.0.jar:na]
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)[sqljdbc4-4.0.jar:na]
    7. com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)[sqljdbc4-4.0.jar:na]
    8. com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)[sqljdbc4-4.0.jar:na]
    8 frames
  3. org.apache.tomcat
    DataSourceProxy.getConnection
    1. org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)[tomcat-jdbc-8.0.36.jar:na]
    2. org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)[tomcat-jdbc-8.0.36.jar:na]
    3. org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:710)[tomcat-jdbc-8.0.36.jar:na]
    4. org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:644)[tomcat-jdbc-8.0.36.jar:na]
    5. org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:466)[tomcat-jdbc-8.0.36.jar:na]
    6. org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)[tomcat-jdbc-8.0.36.jar:na]
    7. org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)[tomcat-jdbc-8.0.36.jar:na]
    8. org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:102)[tomcat-jdbc-8.0.36.jar:na]
    9. org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:126)[tomcat-jdbc-8.0.36.jar:na]
    9 frames
  4. org.hibernate.engine
    DatasourceConnectionProviderImpl.getConnection
    1. org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    1 frame
  5. Hibernate
    JdbcServicesImpl.configure
    1. org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:279)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    2. org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:124)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    2 frames
  6. org.hibernate.boot
    StandardServiceRegistryImpl.configureService
    1. org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    1 frame
  7. Hibernate
    Configuration.buildSessionFactory
    1. org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    2. org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    3. org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    4. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    4 frames
  8. org.hibernate.jpa
    EntityManagerFactoryBuilderImpl$4.perform
    1. org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]
    2. org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]
    2 frames
  9. org.hibernate.boot
    ClassLoaderServiceImpl.withTccl
    1. org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    1 frame
  10. org.hibernate.jpa
    EntityManagerFactoryBuilderImpl.build
    1. org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]
    1 frame
  11. Spring ORM
    AbstractEntityManagerFactoryBean.afterPropertiesSet
    1. org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60)[spring-orm-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    2. org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343)[spring-orm-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    3. org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:319)[spring-orm-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    3 frames
  12. Spring Beans
    AbstractBeanFactory.getBean
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    5. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    6. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    7. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    8. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    8 frames
  13. Spring Context
    AbstractApplicationContext.refresh
    1. org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1054)[spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    2. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:829)[spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    3. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)[spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
    3 frames
  14. Spring Boot
    SpringApplication.run
    1. org.springframework.boot.SpringApplication.refresh(SpringApplication.java:760)[spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
    2. org.springframework.boot.SpringApplication.createAndRefreshContext(SpringApplication.java:360)[spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
    3. org.springframework.boot.SpringApplication.run(SpringApplication.java:306)[spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
    4. org.springframework.boot.SpringApplication.run(SpringApplication.java:1185)[spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
    5. org.springframework.boot.SpringApplication.run(SpringApplication.java:1174)[spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
    5 frames
  15. testApplication
    Application.main
    1. testApplication.Application.main(Application.java:46)[bin/:na]
    1 frame