jTDS em SQL EXPRESS

boa tarde a todos.
Galera, preciso de ajuda.

Eu já fiz testes, já pesquisei no google no forum, mas nada resolveu.
já nao tenho mais onde conseguir ajuda…

estou com problemas para conectar com banco de dados em SQL SERVER EXPRESS 2005 na minha propria maquina, estou usando o jTDS.

Segue o erro…

Des de já Muito Obrigado.

java.sql.SQLException: Network error IOException: Connection refused: connect
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
        at java.sql.DriverManager.getConnection(DriverManager.java:620)
        at java.sql.DriverManager.getConnection(DriverManager.java:200)
        at gestaodeacessos.NCL.db_sql(NCL.java:124)
        at gestaodeacessos.NCL.stm_sql(NCL.java:142)
        at gestaodeacessos.Principal.pesquisa_
        at gestaodeacessos.Principal.pesquisa_sql(Principal.java:419)
        at gestaodeacessos.Principal.tf_principal_usuarioActionPerformed(Principal.java:320)
        at gestaodeacessos.Principal.access$000(Principal.java:25)
        at gestaodeacessos.Principal$1.actionPerformed(Principal.java:99)
        at javax.swing.JTextField.fireActionPerformed(JTextField.java:509)
        at javax.swing.JTextField.postActionEvent(JTextField.java:722)
        at javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:837)
        at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1661)
        at javax.swing.JComponent.processKeyBinding(JComponent.java:2866)
        at javax.swing.JComponent.processKeyBindings(JComponent.java:2901)
        at javax.swing.JComponent.processKeyEvent(JComponent.java:2829)
        at java.awt.Component.processEvent(Component.java:5894)
        at java.awt.Container.processEvent(Container.java:2101)
        at java.awt.Component.dispatchEventImpl(Component.java:4477)
        at java.awt.Container.dispatchEventImpl(Container.java:2159)
        at java.awt.Component.dispatchEvent(Component.java:4303)
        at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1879)
        at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:750)
        at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1015)
        at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:887)
        at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:714)
        at java.awt.Component.dispatchEventImpl(Component.java:4347)
        at java.awt.Container.dispatchEventImpl(Container.java:2159)
        at java.awt.Window.dispatchEventImpl(Window.java:2559)
        at java.awt.Component.dispatchEvent(Component.java:4303)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:604)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:310)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:176)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:163)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:154)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:380)
        at java.net.Socket.connect(Socket.java:569)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:623)
        at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310)
        ... 38 more
CONSTRUÍDO COM SUCESSO (tempo total: 21 segundos)

Você precisa habilitar a conexão por sockets no seu SQL Server 2005. Deve ser alguma coisa do tipo “Surface Area Configuration Tool”.

http://www.developer.com/db/article.php/3496511

Você precisa habilitar o “Enable TCP/IP Protocol”

Amigo…

Muito obrigado, mas nao fucionou.

continua o mesmo erro.

Depois de habilitar o protocolo TCP, é necessário ver se está na porta 1433 ou em outra porta, e reiniciar o SQL Server.