Endpoint Protection

 View Only
  • 1.  Cannot install SQL Database SEM 11.0.5

    Posted Mar 06, 2010 08:01 AM
    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)


  • 2.  RE: Cannot install SQL Database SEM 11.0.5

    Posted Mar 06, 2010 09:44 AM
     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