com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost/SQLEXPR

最新推荐文章于 2025-01-12 21:27:51 发布

转载最新推荐文章于 2025-01-12 21:27:51 发布 · 3k 阅读

收录于

sqlserver

本文详细介绍了如何通过Java JDBC连接到SQL Server Express数据库的方法。包括配置SQL Server Express的步骤、确定端口号、设置Java连接字符串及使用示例代码。

Try running some Java code to test it. Replace {computer-name}\SQLEXPRESS with the domain that you see in the root node of SQL Server Management Studio. When installing SQL Express, you had the option to change the name of "SQLEXPRESS" to something custom, so that might also be different. To get the port number, go to Windows Start Menu > SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager > expand "SQL Server Network Configuration" > Click "Protocols for SQLEXPRESS" > right click "TCP/IP" and choose Properties > click "IP Addresses" tab/menu > in Windows XP, you will see "IPAll" .. look at the port there. It should default to 1433. If you have 2 version of SQL Express, then it might be different. Also make sure your service is running (has status of "Started") in Windows Control Panel > Administrative Tools > Services > SQL Server (SQLEXPRESS). Windows 7 is slightly different, but you'll find it.

The double backslashes need to be in a Java string. That just prints a single backslash during run time because it's an escape sequence.

import java.sql.*;

public class TestConnection
{
    public static void main(String[] args)
    {
        DB db = new DB();
        db.dbConnect("jdbc:sqlserver://{computer-name}\\SQLEXPRESS:1433;databaseName=abc;integratedSecurity=true;","sa","password");
    }
}

class DB
{
    public DB() {}

    public void dbConnect(String db_connect_string, String db_userid, String db_password)
    {
        try
        {
            Connection conn = DriverManager.getConnection(db_connect_string, db_userid, db_password);
            System.out.println("connected");
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
};

参照：http://stackoverflow.com/questions/9256044/jdbc-connection-url-for-sqlserver-express-r2

我把IPAll

tcp动态端口设成了空

tcp端口设成了1433

应为当时我是用的windows身份验证，我改成了sqlserver身份验证参照：http://msdn.microsoft.com/zh-cn/library/ms188670.aspx

最后写成

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		Connection connection = DriverManager.getConnection("jdbc:sqlserver://THINKPAD-PC\\SQLEXPRESS:1433;user=sa;password=xxx");

就连上了