Eclipse connected to SqlServer2008 (it was a terrible mess)

Uncle Jian Min told me to test to do a system requirements to connect SqlServer2008, so I began the "purgatory", people connected to the green light, I was all the way red so decided to record it down, to Yimeimei to provide convenience.

First red light:

Failed to test the connection with CMD after starting the service.

Start menu → Run cmd→ at the command prompt input: telnet 127.0.0.1 1433, (note that there is a space between Telnet and 127, 1 and 1433 spaces) If you are prompted to "cannot open a connection to the host, on port 1433: Connection Failed", Indicates that port 1433 is not open and needs to be re-configured. If the connection is successful, the display is shown in 8:

I did not appear above the interface, but said the command is not recognized.     The test succeeds after changing the port to 1433. Red Light 2: Established Java project with red Exclamation point resolution: Reconfigure Sqljdbc4.jar Path red light 3: Everything is OK or Prompt user Login failed (login name, password is correct), tinkering for a few days finally found SqlServer2008 server is not the Server, change the server name to the computer name and establish a successful connection to the test database.

Eclipse connected to SqlServer2008 (it was a terrible mess)