java - 当我尝试连接数据库时 jdbc.SQLServerException

Question

我有用于从 JavaFx 应用程序连接到数据库的类

public class DBConnection {

public static Connection mcConnection() {
    Connection connection = null;
    try {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url = "jdbc:sqlserver://localhost; databaseName=McQueen_db;";
        connection = DriverManager.getConnection(url);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }

    return connection;
}

}

当我尝试连接时出现异常

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

我检查了我的防火墙，一切正常。我想那个港口也是。有什么想法有什么问题吗？

Answer 1

尝试将“localhost”更改为“127.0.0.1”

有时，您的系统无法正确映射本地主机。

引用official doc