sqlserver2005 安装包下载地址:http://pan.baidu.com/s/1bnq4msv
安装截图:
(1)使用sql server management studio 导入mdf文件
(2)sql server management studio 连接sqlserver2005
连接地址应该是:win7-20070102ua\sqlserver2005
\ 左边是计算机名称或者ip,\ 右边是sqlserver2005 的实例名称
注意:不是服务名,而是实例名,以我的sqlserver2005举例,实例名是sqlserver2005,服务名是:mssql$sqlserver2005
报错com.microsoft.sqlserver.jdbc.sqlserverexception: 到主机 的 tcp/ip 连接失败
com.microsoft.sqlserver.jdbc.sqlserverexception: 到主机 的 tcp/ip 连接失败。 java.net.connectexception: connection refused: connect
at com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdrivererror(unknown source)
at com.microsoft.sqlserver.jdbc.sqlserverconnection.connecthelper(unknown source)
at com.microsoft.sqlserver.jdbc.sqlserverconnection.loginwithoutfailover(unknown source)
at com.microsoft.sqlserver.jdbc.sqlserverconnection.connect(unknown source)
at com.microsoft.sqlserver.jdbc.sqlserverdriver.connect(unknown source)
at java.sql.drivermanager.getconnection(drivermanager.java:571)
at java.sql.drivermanager.getconnection(drivermanager.java:215)
at com.hw.util.dbutil.getconn(dbutil.java:23)
at com.hw.util.dbutil.main(dbutil.java:33)
原因:sqlserver2005 的tcp/ip没有开启,按下图所示开启即可.
注意:sqlserver2005 的jdbc 端口号不是1433,而是58076
java 通过jdbc连接sqlserver2005 代码 :
public class dbutil {
private string driver = "com.microsoft.sqlserver.jdbc.sqlserverdriver";
private string url ="jdbc:sqlserver://localhost:58076;databasename=school";
private string user = "sa";
private string pwd ="1234567";
public connection getconn(){
connection conn = null;
try {
class.forname(driver);
conn = drivermanager.getconnection(url,user,pwd);
} catch (exception e) {
e.printstacktrace();
system.out.println("查看数据库服务器开启");
}
return conn;
}
public static void main(string[] args) {
dbutil dbutil=new dbutil();
system.out.println(dbutil.getconn());
}