mssql java,从Java登录到MSSQL服务器的问题

I am trying to connect to MSSQL server 2008 on my localhost, but I am getting Errors

WARNING: ConnectionID:2 Prelogin error: host 127.0.0.1 port 1434 Error reading prelogin response: Connection reset

this error repeats like 20 times very quickly, then i get

com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset

I suspect this is some wrong configuration of server. I can connect to external servers with no issues. I can also connect via management studio with no problems.

Please help me, I am getting sick of this issue :|

解决方案

1) TCP protocol for MSSQL 2008 is disabled by default. You need to enable it from SQL Configuration Manager (in the same [Start], Programs folder as MSSQL):

2) To use TCP connections (even on localhost!) you need to allow MSSQL in Windows Firewall:

3) You don't necessarily need to use TCP/IP in order to access MSSQL:

'Hope that helps!