Start a new topic

Connecting to SQL Server (jTDS)

[This topic is migrated from our old forums. The original author name has been removed]

Hi , I am trying to connect to SQL Server 2012 DB using DB visualizer ver 9.2. I am not able to connect to at all. I am able to ping the server (localhost) . here is the details. BTWN000426\SQL12DV01 jdbc:jtds:sqlserver://localhost:58012;DatabaseName=SQL12DV01 Product: DbVisualizer Free 9.2 [Build #2348] OS: Windows Server 2008 R2 OS Version: 6.1 OS Arch: amd64 Java Version: 1.7.0_72 Java VM: Java HotSpot(TM) 64-Bit Server VM Java Vendor: Oracle Corporation Java Home: c:\program files\dbvisualizer\jre DbVis Home: C:\Program Files\DbVisualizer User Home: C:\Users\svc_laserfiche_dv PrefsDir: C:\Users\svc_laserfiche_dv\.dbvis Look and Feel: WindowsLookAndFeel Screen 1: size: 1280 x 1024, refresh rate: 60, bit depth: 16 Monitor Running: No *** JVM Options (Application) ********************** -Xmx512m -XX:MaxPermSize=192m -Dsun.locale.formatasdefault=true -include-options ${USERPROFILE}\.dbvis\user.vmoptions -include-options ${HOME}/.dbvis/user.vmoptions *** Database Properties **************************** Alias: TIMS Development Settings Format: Server Info URL: jdbc:jtds:sqlserver://localhost:58012;DatabaseName=SQL12DV01 Driver: SQL Server (jTDS) Userid: TELUS\svc_laserfiche_dv Preferred Database Type: sqlserver Current Database Type: sqlserver Preferred Profile: auto Current Profile: null (not connected?) --- Object Type Settings --------------------------- None --- Overridden User Properties --------------------- No properties defined in this PropsManager! --- Overridden Driver Properties ------------------- No overridden driver properties! *** End Database Properties ************************ *** Driver Information ***************************** Name: SQL Server (jTDS) DefaultDriver: true URLFormat: jdbc:jtds:sqlserver://:;DatabaseName= isReady: true DefaultClass: net.sourceforge.jtds.jdbc.Driver Paths: Path: C:\Program Files\DbVisualizer\jdbc\jtds\jtds.jar Type: dynamic Classes: net.sourceforge.jtds.jdbc.Driver *** End Driver Information ************************* *** Current Connection Message ********************* An error occurred while establishing the connection: Long Message: I/O Error: DB server closed connection. Details: Type: java.sql.SQLException SQL State: 08S01 *** End Current Connection Message *****************
1 Comment

[This reply is migrated from our old forums.]

Re: Connecting to SQL Server (jTDS)
Hi Prakash, Please upgrade to the latest version, 9.2.1. If you still cannot connect, please open Tools->Debug Window and enable debugging for DbVisualizer. Then try to connect again and include the debug output in your reply. Best Regards, Hans