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 | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    Stack Overflow | 8 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 | 11 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

    SQL login failed

    GitHub | 5 months ago | xiao-liu-noisychannels
    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "mydatebase" requested by the login. The login failed. ClientConnectionId:c9356740-0180-4bd1-8277-39a0e7234d81
  6. 0

    Springboot application - Unable to create initial connections of pool (SQL Server)

    Stack Overflow | 1 month ago | santafebound
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'TMTAdmin'. ClientConnectionId:0f665431-7f24-49a7-b900-e966db1eb14a
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