Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Cannot install SQL Database SEM 11.0.5

Created: 06 Mar 2010 • Updated: 08 Sep 2010 | 1 comment

Hi,

I've tried installing a couple of servers,. running both Win 2003SP2 and Win 2008 and I keep getting the same error on both installs.
SEM installs fine but when I try and configure a SQL database I get the error 'Initialization of the database failed.

Below is the install_log.err file. Has anyone else had this and managed to fix it?

Thanks Nigel

java.sql.SQLException: I/O Error: DB server closed connection.
 at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1038)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:436)
 at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:402)
 at com.sygate.scm.install.ui.PackageHandler.addBinaryFile(PackageHandler.java:279)
 at com.sygate.scm.install.ui.PackageHandler.addBinaryFile(PackageHandler.java:234)
 at com.sygate.scm.install.ui.PackageHandler.addPhysicalFile(PackageHandler.java:209)
 at com.sygate.scm.install.ui.PackageHandler.addPackage(PackageHandler.java:295)
 at com.sygate.scm.install.ui.PackageHandler.importPackages(PackageHandler.java:86)
 at com.sygate.scm.install.ui.MainFrame.importPackages(MainFrame.java:1967)
 at com.sygate.scm.install.ui.MainFrame.initializeData(MainFrame.java:2173)
 at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1263)
 at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:826)
 at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:180)
 at com.sygate.scm.install.ui.MainFrame$3$1.construct(MainFrame.java:607)
 at com.sygate.scm.install.util.SwingWorker$2.run(SwingWorker.java:121)
 at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.IOException: DB server closed connection.
 at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:816)
 at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:695)
 at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:443)
 at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:102)
 at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:87)
 at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3772)
 at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1031)
 ... 15 more
java.sql.SQLException: Invalid state, the Connection object is closed.
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1305)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:1978)
 at com.sygate.scm.install.ui.MainFrame.initializeData(MainFrame.java:2219)
 at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1263)
 at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:826)
 at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:180)
 at com.sygate.scm.install.ui.MainFrame$3$1.construct(MainFrame.java:607)
 at com.sygate.scm.install.util.SwingWorker$2.run(SwingWorker.java:121)
 at java.lang.Thread.run(Thread.java:619)

Comments 1 CommentJump to latest comment

Vikram Kumar-SAV to SEP's picture

 Follow this doc top to bottom to make sure everything is configured properly in Studio and SQL management

http://service1.symantec.com/support/ent-security.nsf/854fa02b4f5013678825731a007d06af/8ed22363812c4c8388257456004df257?OpenDocument

Vikram Kumar

Symantec Consultant

The most helpful part of entire Symantec connect is the Search button..do use it.