Page 1 of 1

Reverse Engineering SQL Server 2008 Schema

PostPosted: Mon Aug 23, 2010 12:12 pm
by brandon.gibson@lmco.com
I am having difficulty reverse engineering an SQL Server 2008 schema using MagicDraw.

I have tried both the 2.0 and the 3.0 versions of the jdbc driver for SQL Server, but the only status I receive is "Connection failed!"

Re: Reverse Engineering SQL Server 2008 Schema

PostPosted: Tue Aug 24, 2010 1:18 am
by Justinas Bisikirskas
Hi,
It could be possible that you provide the incorrect DB Connection URL or use the incorrect JDBC driver class .
The older JDBC drivers of SQL server and the new ones have some changes in this area.

If you use JDBC 2.0/3.0 driver, the DB Connection URL shall be : "jdbc:sqlserver://<server.address>".
The driver class also should be updated to "com.microsoft.sqlserver.jdbc.SQLServerDriver".

Please try to update these values and let us know if it does not help.

--

Best regards,

Justinas Bisikirskas

Re: Reverse Engineering SQL Server 2008 Schema

PostPosted: Tue Aug 24, 2010 7:26 am
by brandon.gibson@lmco.com
Could you clarify what you mean by host.address...

I had already changed the driver URL and the driver name but I was still having the same issue.

When I put in host.address I get the following exception...

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host mvnswft2.158.187.195.29, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1033)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at com.nomagic.magicdraw.ce.ddl.g.f(g.java:124)
at com.nomagic.magicdraw.ce.ddl.g.c(g.java:45)
at com.nomagic.magicdraw.ce.ddl.v.r(v.java:79)
at com.nomagic.magicdraw.ce.core.e.rb.a(rb.java:186)
at com.nomagic.magicdraw.ce.core.e.rb.a(rb.java:462)
at com.nomagic.magicdraw.ce.core.rtproject.objects.p.accept(p.java:162)
at com.nomagic.magicdraw.ce.core.e.rb.c(rb.java:107)
at com.nomagic.magicdraw.ce.core.r.a(r.java:435)
at com.nomagic.magicdraw.ce.core.r.a(r.java:423)
at com.nomagic.magicdraw.ce.core.r.c(r.java:752)
at com.nomagic.magicdraw.ce.core.r.b(r.java:729)
at com.nomagic.magicdraw.ce.core.e.ub.actionPerformed(ub.java:44)
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.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.nomagic.utils.EventTracker.dispatchEvent(EventTracker.java:33)
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)
SQLState(08S01) vendor code(0)

Re: Reverse Engineering SQL Server 2008 Schema

PostPosted: Tue Aug 24, 2010 7:47 am
by jusbis
Please check if your SQL server allows remote connections.
More information about this error could be found at http://social.msdn.microsoft.com/Forums ... 3943180172

Re: Reverse Engineering SQL Server 2008 Schema

PostPosted: Tue Aug 24, 2010 10:07 am
by brandon.gibson@lmco.com
Thanks for the help. We were able to resolve the issue.

The DDL import works great :D

Re: Reverse Engineering SQL Server 2008 Schema

PostPosted: Tue Jun 19, 2018 2:08 pm
by dellprintersupport
The process where engineering is finding the error on the driver of the SQL server which is going to be solved out fro which you can take the support fromDell printer supportwhich will be the best part.