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.
参照:http://stackoverflow.com/questions/9256044/jdbc-connection-url-for-sqlserver-express-r2
就连上了
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");
就连上了