java - 通过 JDBC 连接到 MS SQL Server 引发 SQLServerException

Question

我知道这个问题之前已经被问过很多次了。然而我似乎无法做对。

我正在尝试使用 Java 连接到本地 MS SQL 服务器实例(使用 .NET 连接到此服务器没有问题)。

我正在使用 sqljdbc.jar 库和以下代码:

String url = "jdbc:microsoft:sqlserver://";
String serverName= "MPRSNT2765/SQLEXPRESS";
String portNumber = "1433";
String databaseName= "MogGPS";
String un = "admin";
String pw = "admin";        
String selectMethod = "cursor"; 

String connectionUrl = url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = java.sql.DriverManager.getConnection(connectionUrl,un,pw);

我得到以下堆栈跟踪:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host MPRSNT2765/SQLEXPRESS, port 1433 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241) at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243) at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at bcapi.SQL.Init(SQL.java:29) at bcapi.App3.main(App3.java:33)

我做错了什么？

Answer 1

从 URL 中删除“microsoft”:

String url = "jdbc:sqlserver://";