java - 我想从 Eclipse 连接到 SSMS 数据库，但它抛出 SQLserverException

Question

我想从 eclipse 连接到 SSMS 数据库。当编译器到达 DriverManager.getConnection(url) 行时，它会抛出错误。我也启用了 TCP/IP，但它给出了错误。

try{            
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        System.out.println("driver loaded successfully");
        connection= DriverManager.getConnection( "jdbc:sqlserver://localhost\\MSSQLSERVER;user=sa;password=coder182");
        System.out.println("Connection created successfully");
        connection.setAutoCommit( autoCommit);
        statement=connection.createStatement();

        String query ="insert into User_information(name, card_no,amount)" + "values ('"+name+"','"+card_no+"', '"+amount+"');";
        statement.executeUpdate(query);

        System.out.println(query);                      
    }catch(Throwable th){
        th.printStackTrace();
    }           
}

错误:

com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host localhost, named instance mssqlserver 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.

我想将它连接到数据库。

Answer 1

• 打开 SQL Server 配置管理器
• SQL Server 网络配置
• MSSQLSERVER 协议(protocol)
• TCP/IP(必须已启用或已启用)
• (双击)
• IP 地址
• 向下滚动到 IPALL
• 输入端口号 1433 或 1434，并将动态端口留空，然后应用设置并重新启动服务

并且您必须指定要连接的数据库名称

"jdbc:sqlserver://localhost;instance=MSSQLSERVER;databaseName=name_of_database;user=sa;password=your_password;"

如果问题已解决，则将答案标记为已接受