Endpoint Protection

 View Only
Expand all | Collapse all

Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

Rafeeq

RafeeqDec 07, 2010 11:55 PM

Migration User

Migration UserDec 08, 2010 02:18 PM

  • 1.  Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 07, 2010 07:10 PM

    I am unable to complete the Symantec EndPoint Protection Configuration Wizard due to errors:

    Here are the configurations for the the last three wizard screens before the errors appear:

    Database Type: Microsoft SQL Server

    Create a new database

    Database Server: ServerName\InstanceName
    SQL Server Port: 1433
    Database Name: sem5
    Authentication: Windows Authentication
    User: sem
    Password: ***************
    Confirm Password: ***************
    SQL Client Folder: C:\Program Files\Microsoft SQL Server\100\Tools\Binn
    Database data folder:

    If I click the the Default button next to the Database data folder field, this error appears:

    Failed to connect to database

    If I specify a data folder C:\Program Files\Microsoft SQL Server\MSSQL10_50.InstanceName\MSSQL\DATA then this error appears:

    Error 11501: Unable to create the database for Symantec Enpoint Protection Manager.  Please click here for more information.

    I've already searched the support site and forums for resolution to these error messages.  No previous posts applied or resolved the issues.

    The Installation documentation (if you can call it that) equivocates on if the "user" account should already exist.  I tried installing under two scenarios: account exist and account not exist.  Under the account exist scenario, the sem account had local admin rights and was also a login account with sysadmin rights in the SQL Serve Management Studio.

    Server Notes:

    • Windows 2008 R2 with SQL 2008 R2 Installed
    • Symantec_Endpoint_Protection_11.0.6_MP2_Trialware_Xplat_EN
    • Workgroup (not part of a domain)
    • Using Remote Desktop to connect to server (since it is in another state)
    • Windows Firewall Enabled (corporate policy)
    • Configured Windows Firewall to Allow SQL Exception (see http://support.microsoft.com/kb/968872 )
    • Configured SQL to enable TCP/IP for InstanceName on port 1433



     



  • 2.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 07, 2010 11:55 PM

    have you installed the sql client?



  • 3.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 12:17 AM

    Are you able to login to SQL server from SEPM server using the SQL client which is present in SEPM ?

    Try by using SQL authentication.....



  • 4.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 02:15 AM

    To my best knowledge, SEP Manager do not support database on SQL Server 2008 R2. It should install well with SQL Server 2008 verions.

     

    Just to be sure, may you please run a pre-install check with the SEP tool?

    Please download the tool from the link below,

    http://www.symantec.com/business/support/index?page=content&id=TECH105414



  • 5.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 03:16 AM

    User: sem has got all necessary rights and permissions to create a DB?



  • 6.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 01:44 PM

    I'm not sure if this is answering your question, but I can log in to the SQL Server Management using Windows Authencation.  When i instlaled, SQL 2008 R2 I used Windows Authentication. 

    Also I don't know what you mean by:

    Are you able to login to SQL server from SEPM server using the SQL client which is present in SEPM ?

    The SQL Server and the SEPM are the same server.  Also the Management Console was installed via SQL, not the SEPM.  Is there another client instlaled?  If so how can I access it?



  • 7.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 02:01 PM

    Test ODBC Connection

     

      For an SQL database
      1. Verify the following:
        • You specified a named instance during installation and configuration. For example: \\<server name=""><server name>\<instance name> <instance name=""></instance></server>
        • The SQL Server is running and properly configured
        • The network connections between Symantec Endpoint Protection Manager and the SQL database. 
           
      2. Test the ODBC connection.
        1. Open Control Panel > Administrator Tools
        2. Double click Data Sources (ODBC)
        3. On the System DSN tab, double-click SymantecEndpointSecurityDSN
        4. Go through the wizard to ensure the following settings:

          Name: SymantecEndpointSecurityDSN
          Description: <Anything><anything>
          Server: Servername\InstanceName </anything>
          (Only enter the server name or IP address if using the default instance)
          Login ID: sa
          Password: <password></password>
          <password>
           
        5. Leave the defaults for the rest of the items and click Finish
        6. Click Test Data Source , it should return "Success"
        7. Click OK


  • 8.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 02:02 PM

    Ran the tool and it seemed successful.  Here the results:

    Error

    Unable to communicate with the reporting component after logging to the Symantec Endpoint Protection Manager

    Tests Error The user identity for the DefaultAppPool is set to User in UserNameWAM. It should be set to Network Service or Local System

    Subcategory Ports
    Click for more -> Which communication ports does the Symantec Endpoint Protection Manager 11.x use?

    Tests
    Error No applications are using Tomcat's configured port of '8005' with a state of 'Listen'
    Error No applications are using Remote Console Logon's configured port of '9090' with a state of 'Listen'

     

    Seems like neither of these should prohibit a SQL connection/DB creation.

    Should I attach the full data report?



  • 9.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 02:12 PM


  • 10.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 02:18 PM

    ODBC Connection test was succcessful.



  • 11.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 02:51 PM

    This article was nearly identical to the Installation Guide (which I initially followed).  I double checked all the settings and they were all configured appropriately.  I still get the errors.



  • 12.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 02:53 PM

    Microsoft SQL Server Native Client 10.0 is installed when you install SQL Server 2008 R2 or the SQL Server tools. (see http://msdn.microsoft.com/en-us/library/ms131321.aspx)

    And I installed the server tools.



  • 13.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 03:03 PM

    The 'sem' account has 'sysadmin' rights in SQL.  Is that sufficient?



  • 14.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 05:29 PM

    It is not supported but onthe other hand I see no reason why it should not install correctly...



  • 15.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 05:33 PM

    Could you pplease paste here the log:

    \Symantec Endpoint Protection Manager\tomcat\logs\catalina.out

    please? I suspect it is realted to Java-SQL exception.



  • 16.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 08, 2010 06:52 PM

    I don't see a log titled Catalina.out.

    The only logs i see in "C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\logs" are

    backup.err

    java.sql.SQLException: Login failed for user 'sem5'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
        at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:591)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:335)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.tools.util.Utility.getConnection(Utility.java:117)
        at com.sygate.scm.tools.DatabaseFrame.getLocalSite(DatabaseFrame.java:545)
        at com.sygate.scm.tools.DatabaseFrame.getBackupButton(DatabaseFrame.java:189)
        at com.sygate.scm.tools.DatabaseFrame.getActionsPanel(DatabaseFrame.java:398)
        at com.sygate.scm.tools.DatabaseFrame.initialize(DatabaseFrame.java:152)
        at com.sygate.scm.tools.DatabaseFrame.<init>(DatabaseFrame.java:137)
        at com.sygate.scm.tools.DatabaseFrame.main(DatabaseFrame.java:1277)

     

    install_log.err

    java.sql.SQLException: Network error IOException: Connection refused: connect
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.install.ui.SqlPropPanel.btnLoadPath_actionPerformed(SqlPropPanel.java:1119)
        at com.sygate.scm.install.ui.SqlPropPanel.access$200(SqlPropPanel.java:53)
        at com.sygate.scm.install.ui.SqlPropPanel$2.actionPerformed(SqlPropPanel.java:183)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6263)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
        at java.awt.Component.processEvent(Component.java:6028)
        at java.awt.Container.processEvent(Container.java:2041)
        at java.awt.Component.dispatchEventImpl(Component.java:4630)
        at java.awt.Container.dispatchEventImpl(Container.java:2099)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
        at java.awt.Container.dispatchEventImpl(Container.java:2085)
        at java.awt.Window.dispatchEventImpl(Window.java:2475)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
    Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:519)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
        ... 32 more
    java.sql.SQLException: Network error IOException: Connection refused: connect
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.install.ui.SqlPropPanel.checkDBConnection(SqlPropPanel.java:972)
        at com.sygate.scm.install.ui.SqlPropPanel.getNextStage(SqlPropPanel.java:538)
        at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:762)
        at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:183)
        at com.sygate.scm.install.ui.MainFrame$3$1.construct(MainFrame.java:617)
        at com.sygate.scm.install.util.SwingWorker$2.run(SwingWorker.java:121)
        at java.lang.Thread.run(Thread.java:619)
    Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:519)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
        ... 11 more
    SqlPropPanel >> CheckDBConnection > Fail to connect to database. Vendor's error code is [0], SEPM's error code is [11501]. Error message is [Network error IOException: Connection refused: connect].
    URL link: ["http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.6200.754&language=english&module=Console&error=11501&build=symantec_ent"]
    java.sql.SQLException: Network error IOException: Connection refused: connect
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.install.ui.SqlPropPanel.btnLoadPath_actionPerformed(SqlPropPanel.java:1119)
        at com.sygate.scm.install.ui.SqlPropPanel.access$200(SqlPropPanel.java:53)
        at com.sygate.scm.install.ui.SqlPropPanel$2.actionPerformed(SqlPropPanel.java:183)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6263)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
        at java.awt.Component.processEvent(Component.java:6028)
        at java.awt.Container.processEvent(Container.java:2041)
        at java.awt.Component.dispatchEventImpl(Component.java:4630)
        at java.awt.Container.dispatchEventImpl(Container.java:2099)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
        at java.awt.Container.dispatchEventImpl(Container.java:2085)
        at java.awt.Window.dispatchEventImpl(Window.java:2475)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
    Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:519)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
        ... 32 more
    java.sql.SQLException: Network error IOException: Connection refused: connect
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.install.ui.SqlPropPanel.checkDBConnection(SqlPropPanel.java:972)
        at com.sygate.scm.install.ui.SqlPropPanel.getNextStage(SqlPropPanel.java:538)
        at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:762)
        at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:183)
        at com.sygate.scm.install.ui.MainFrame$3$1.construct(MainFrame.java:617)
        at com.sygate.scm.install.util.SwingWorker$2.run(SwingWorker.java:121)
        at java.lang.Thread.run(Thread.java:619)
    Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:519)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
        ... 11 more
    SqlPropPanel >> CheckDBConnection > Fail to connect to database. Vendor's error code is [0], SEPM's error code is [11501]. Error message is [Network error IOException: Connection refused: connect].
    URL link: ["http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.6200.754&language=english&module=Console&error=11501&build=symantec_ent"]
    java.sql.SQLException: Network error IOException: Connection refused: connect
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.install.ui.SqlPropPanel.btnLoadPath_actionPerformed(SqlPropPanel.java:1119)
        at com.sygate.scm.install.ui.SqlPropPanel.access$200(SqlPropPanel.java:53)
        at com.sygate.scm.install.ui.SqlPropPanel$2.actionPerformed(SqlPropPanel.java:183)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6263)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
        at java.awt.Component.processEvent(Component.java:6028)
        at java.awt.Container.processEvent(Container.java:2041)
        at java.awt.Component.dispatchEventImpl(Component.java:4630)
        at java.awt.Container.dispatchEventImpl(Container.java:2099)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
        at java.awt.Container.dispatchEventImpl(Container.java:2085)
        at java.awt.Window.dispatchEventImpl(Window.java:2475)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
    Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:519)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
        ... 32 more
    java.sql.SQLException: Unable to get information from SQL Server: DCFBIWSUS01.
        at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:259)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.install.ui.SqlPropPanel.checkDBConnection(SqlPropPanel.java:972)
        at com.sygate.scm.install.ui.SqlPropPanel.getNextStage(SqlPropPanel.java:538)
        at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:762)
        at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:183)
        at com.sygate.scm.install.ui.MainFrame$3$1.construct(MainFrame.java:617)
        at com.sygate.scm.install.util.SwingWorker$2.run(SwingWorker.java:121)
        at java.lang.Thread.run(Thread.java:619)
    SqlPropPanel >> CheckDBConnection > Fail to connect to database. Vendor's error code is [0], SEPM's error code is [11501]. Error message is [Unable to get information from SQL Server: DCFBIWSUS01.].
    URL link: ["http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.6200.754&language=english&module=Console&error=11501&build=symantec_ent"]
    java.sql.SQLException: Unable to get information from SQL Server: DCFBIWSUS01.
        at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:259)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at com.sygate.scm.install.ui.SqlPropPanel.checkDBConnection(SqlPropPanel.java:972)
        at com.sygate.scm.install.ui.SqlPropPanel.getNextStage(SqlPropPanel.java:538)
        at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:762)
        at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:183)
        at com.sygate.scm.install.ui.MainFrame$3$1.construct(MainFrame.java:617)
        at com.sygate.scm.install.util.SwingWorker$2.run(SwingWorker.java:121)
        at java.lang.Thread.run(Thread.java:619)
    SqlPropPanel >> CheckDBConnection > Fail to connect to database. Vendor's error code is [0], SEPM's error code is [11501]. Error message is [Unable to get information from SQL Server: DCFBIWSUS01.].
    URL link: ["http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.6200.754&language=english&module=Console&error=11501&build=symantec_ent"]

    install_log.out (empty/no data)

    smbinstall_log.err (empty/no data)

    smbinstall_log.out

    Has valid SAV license
    Has valid SNAC license
    Saving welcome panel data ...
    Saving welcome panel data...
    Advanced option selected...
    Saving company size panel data ...
    Checking disk/memory size(Bytes) requirement...
    Required disk/memory size(Bytes): 2147483648/268435456
    Checking available disk/memory size(Bytes)...
    Available disk/memory size(Bytes): 53536727040/12875354112
    Saving companySize Panel user settings:
    Company size: 3
    Content revision number:3
    DB backup number: 2
    Starting db configuration process...



  • 17.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2



  • 18.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 09, 2010 03:04 AM

    From the logs provided the error we have here is:

    java.sql.SQLException: Network error IOException: Connection refused: connect

    1. Please check again credentials provided when you create the database.

    2. Try giving IP address instead of hostname of SQL server during installation.

    3. Might be a port conflict. Maybe port 2638 on SQL server is alredy in use?



  • 19.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 09, 2010 05:51 PM

    I ran MSInfo32.exe (Start > Programs > Accessories > System Tools > System Information) and the User Name = "Not Available".

    I've tried to connect to the console session, but haven't been able to.  When I try to use TSCon.exe here is the output:

    C:\Users\Administrator>tscon.exe 1
    Could not connect sessionID 1 to this session, Error code 5023
    Error [5023]:The group or resource is not in the correct state to perform the re
    quested operation.

    Despite this, I was able to install SQL and WSUS on the server.  WSUS created a new SQL database just fine.  It leads me to believe that this isn't the problem.



  • 20.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 09, 2010 05:54 PM
    1. Credential are correct.
    2. Using the IP Address in place of the computer named yeilded the same results.
    3. Port 2638? That's a port for SQL Anywhere.  The port I'm using is 1433 for Microsoft SQL Server.


  • 21.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2
    Best Answer

    Posted Dec 09, 2010 06:04 PM

    I am sorry, you are right about ports' numbers. Bu the port on SQL server is set as static, right?

    Are you sure remote connection on the SQL server is enabled? The error means that the server is refusing the connection..



  • 22.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 09, 2010 06:43 PM

    Remote connection wasn't enabled...

    The "SQL Server Browser" service was disabled. So I changed the startup type to Automatic and started the service.

    I also changed the Authetication Mode in the Microsoft SQL Server Management Studio for the Instance.

    1. Log into the Microsoft SQL Server Management Studio and connect to the Instance.
    2. Right Click the instance and select Properties.
    3. Select the Security page..
    4. Chagne Server Authentication to SQL Server and Windows Authenication mode.

    Restart the Instance.

    Now in the setup, I can get past the problem screen and create a system administrator account.

    Thanks!!!!



  • 23.  RE: Endpoint Protection Manager Configuration Error on Windows 2008 R2 with SQL 2008 R2

    Posted Dec 11, 2010 03:27 PM

    Told ya ;)

    Actually my post should have been marked as solution but well... ;-) Glad that it works anyway :-)