博客

1:调用代码如下：

package com.rt.plm.document;

import java.sql.Connection;
import java.sql.DriverManager;

public class test {

	public static void main(String[] args) {
		String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String dbURL="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MSSQLSERVER";
        String userName="infodba";
        String userPwd="Pass1234";
         try
       {
           Class.forName(driverName);
           Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
           System.out.println(dbConn);
           System.out.println("success!");
        }
         catch(Exception e)
      {
           e.printStackTrace();
           System.out.print("fail!");
      }
	}
}

2:报错信息如下：

com.microsoft.sqlserver.jdbc.SQLServerException: 无法打开登录所请求的数据库 "MSSQLSERVER"。登录失败。 ClientConnectionId:1fa14c69-7703-45c9-8eff-6d30339f2085
fail!	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254)
	at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:258)
	at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:104)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4772)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3581)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:81)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3541)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2395)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:700)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.rt.plm.document.test.main(test.java:16)

3:我这边抱错是因为数据库实例名称错误，根据下面命令查询sqlserver数据库的实例名称

4：将实例名称改成查询出来的名称就能连接成功