[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
Hans Bergsten
said
over 9 years ago
[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
anonymous