Connection Problem for sql server


#1

Hi

i wanted to connect to sql server 2008 R2

i read the article that was about this topic and followed its steps.

but after entering information in database configuration window it cannot connect to sql server

this is the log file :

Test adapter connection failed!
v.xyq: Connection timeout!
at v.ajaw.a(:62)
at v.clu.b(:107)
at v.bawv.actionPerformed(:970)
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.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at v.mnr.show(:427)
at v.kfm.g(:740)
at v.kfm.show(:750)
at v.rov.a(:61)
at v.apjh.a(:126)
at v.blsy.a(:440)
at v.zeu.c(:2060)
at v.ajfs.a(:4471)
at v.avja.c(:165)
at v.ajmd.actionPerformed(:61)
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.AbstractButton.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.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.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(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)


#2

Hi danitiger33,

Thank you for your message and I’m sorry about your problem. Please reference to the following knowhow page about how to solve the connection problem with SQL Server. Feel free to contact me for any questions and wish you have a good day!

Best regards,
Rain Wong


#3

I’m having the same problem with oracle connection. is there a solution for that ?


#4

Hi,

Can you provide more details and your log file? It can be exported from the About dialog.
You can send it to support-team@visual-paradigm.com and include the link to this post (https://forums.visual-paradigm.com/t/connection-problem-for-sql-server/12458/3) in the Email.


#5

Are you sure that you can actually reach the host? For example, if you open a command line and then try to ping its IP address, does this give you a response?

Thing is: a connection timeout usually indicates that the connection between the client and server was somehow interrupted. The most common problem is a firewall which doesn’t provide access. Note: this can apply to incoming traffic (so it would be caused by the firewall on the server) but can just as well apply to outgoing traffic (in which case it would be caused by a local firewall (so on the client)).

I’d start there: try to rule out these possible causes by first ensuring that you can actually reach the database server.

Keep in mind that if you try to connect to a remote database server then your local firewall will need to grant access to the Java runtime. I know that some people are focused on providing Visual Paradigm access but that would ignore the fact that Visual Paradigm is build upon Java.

Hope this can also help!