I use the JDBC connection sql2012, each link connection can succeed the first time, resources are released closed
, but the second failure, restart the service item and then only link for the first time,
JDBC code to connect others machines sql2008 perfectly normal,
Feeling is your sql2012 configuration has a problem, but I don't know where to go wrong,
Exception code is as follows: the 015-11-29 22:26:35 com. Microsoft. Essentially. JDBC. SQLServerConnection Prelogin
Warning: ConnectionID: 1 ClientConnectionId: 9174705-48 c d4b - b3b9 f7-4-9 c4261144871 Prelogin error: host localhost port 1533 error reading Prelogin response: Connection reset ClientConnectionId: 48 d4b f7-4 - c - 9174705 b3b9-9 c4261144871
Com. Microsoft. Essentially. JDBC. SQLServerException: Connection reset ClientConnectionId: 48 d4b f7-4 - c - 9174705 b3b9-9 c4261144871
At com. Microsoft. Essentially. JDBC. SQLServerConnection. The terminate (SQLServerConnection. Java: 1667)
At com. Microsoft. Essentially. JDBC. SQLServerConnection. The terminate (SQLServerConnection. Java: 1654)
At com. Microsoft. Essentially. JDBC. TDSChannel. Read (1789) IOBuffer. Java:
At com. Microsoft. Essentially. JDBC. SQLServerConnection. Prelogin (SQLServerConnection. Java: 1424)
At com. Microsoft. Essentially. JDBC. SQLServerConnection. ConnectHelper (SQLServerConnection. Java: 1319)
At com. Microsoft. Essentially. JDBC. SQLServerConnection. Login (SQLServerConnection. Java: 991)
At com. Microsoft. Essentially. JDBC. SQLServerConnection. Connect (SQLServerConnection. Java: 827)
At com. Microsoft. Essentially. JDBC. SQLServerDriver. Connect (SQLServerDriver. Java: 1012)

CodePudding user response:

SQL Server Manager Studio normal connection has a problem, for a period of time after Service will be down

CodePudding user response:

Everything is normal, with vs link also has no problem, JDBC to appear this situation