很多朋友碰到过：
java.sql.sqlexception: [microsoft][sqlserver 2000 driver for jdbc]error establishing socket.
at com.microsoft.jdbc.base.baseexceptions.createexception(unknown source)
at com.microsoft.jdbc.base.baseexceptions.getexception(unknown source)
at com.microsoft.jdbc.base.baseexceptions.getexception(unknown source)
at com.microsoft.jdbc.sqlserver.tds.tdsconnection.(unknown source)
at com.microsoft.jdbc.sqlserver.sqlserverimplconnection.open(unknown source)
at com.microsoft.jdbc.base.baseconnection.getnewimplconnection(unknown source)
at com.microsoft.jdbc.base.baseconnection.open(unknown source)
at com.microsoft.jdbc.base.basedriver.connect(unknown source)
at java.sql.drivermanager.getconnection(unknown source)
at java.sql.drivermanager.getconnection(unknown source)
at ldg.quotation.initdataconn(quotation.java:374)
at ldg.quotation.jbinit(quotation.java:367)
at ldg.quotation.(quotation.java:147)
at ldg.spmk.jbutton1_actionperformed(spmk.java:76)
at ldg.spmk_jbutton1_actionadapter.actionperformed(spmk.java:101)
at javax.swing.abstractbutton.fireactionperformed(unknown source)
at javax.swing.abstractbutton$handler.actionperformed(unknown source)
at javax.swing.defaultbuttonmodel.fireactionperformed(unknown source)
at javax.swing.defaultbuttonmodel.setpressed(unknown source)
at javax.swing.plaf.basic.basicbuttonlistener.mousereleased(unknown source)
at java.awt.component.processmouseevent(unknown source)
at javax.swing.jcomponent.processmouseevent(unknown source)
at java.awt.component.processevent(unknown source)
at java.awt.container.processevent(unknown source)
at java.awt.component.dispatcheventimpl(unknown source)
at java.awt.container.dispatcheventimpl(unknown source)
at java.awt.component.dispatchevent(unknown source)
at java.awt.lightweightdispatcher.retargetmouseevent(unknown source)
at java.awt.lightweightdispatcher.processmouseevent(unknown source)
at java.awt.lightweightdispatcher.dispatchevent(unknown source)
at java.awt.container.dispatcheventimpl(unknown source)
at java.awt.window.dispatcheventimpl(unknown source)
at java.awt.component.dispatchevent(unknown source)
at java.awt.eventqueue.dispatchevent(unknown source)
at java.awt.eventdispatchthread.pumponeeventforhierarchy(unknown source)
at java.awt.eventdispatchthread.pumpeventsforhierarchy(unknown source)
at java.awt.eventdispatchthread.pumpevents(unknown source)
at java.awt.eventdispatchthread.pumpevents(unknown source)
at java.awt.eventdispatchthread.run(unknown source)
这类错误
我也碰到同样问题，打了sql server sp3包后仍然不起作用，后来发现connection con=drivermanager.getconnection("jdbc:microsoft:sqlserver://server_name:1433","username","password");
其中server_name用的是局域网ip,通过公网不能访问，我尝试改成公网可以访问的静态ip，当然数据库就装在这机器上，就可以了。
蒯正建 kennykuai@tom.com 欢迎分享讨论