com.microsoft.sqlserver.jdbc.SQLServerException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

If you're not using yet, consider using the SQLServerDataSource to set your server configurations. Also, check if the server is accepting TCP/IP connections and if there's no firewall blocking the connections.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Failure to connect to sql server 2008 instance
    via Stack Overflow by mschr
    ,
    • com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host XXXXXX, named instance YYYYYY failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(SQLServerConnection.java:3589) at com.microsoft.sqlserver.jdbc.SQLServerConnection.primaryPermissionCheck(SQLServerConnection.java:1225) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:972) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at com.ataccama.dqc.commons.sql.util.SimpleDataSource.getConnection(SimpleDataSource.java:86) at com.ataccama.dqc.internal.commons.sql.AtcDataSource.getConnection(AtcDataSource.java:46) at com.ataccama.dqc.commons.sql.util.SimpleDataSource.getConnection(SimpleDataSource.java:70) at com.ataccama.dqc.internal.commons.sql.AtcDataSource.getConnection(AtcDataSource.java:41) at com.ataccama.dqc.commons.sql.DataSourceImpl.getRawConnection(DataSourceImpl.java:96) at com.ataccama.dqc.commons.sql.DataSourceImpl.getNonTransactionalConnection(DataSourceImpl.java:64) at com.ataccama.dqc.gui.ui.wizards.database.DatabaseConnectionModel.testConnection(y:954) at com.ataccama.dqc.gui.ui.wizards.database.NewDatabasePage$1.run(y:1147) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    odd
    4 times, last one,
    SteVio1989
    2 times, last one,
    110 more bugmates