Network Access Control

Hi,

Trying to install SNAC on the SEPM and error message "unable to get the database schema version.  You must ensure that the database server is working and can be connected to the management servers".  Any ideas please?

SEPM ru 5
SNAC ru5

Hi,

Could you please confirm with the service for Symantec Endpoint Protetion Manager is running?

Please post the upgrade.log from C:\prg files\ symantec\ sepm\tomcat\logs

Aniket

Hi, Yes sepm service is started.

Server HomeD:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat
java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
 at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:188)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:137)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:285)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:276)
 at com.sygate.scm.server.upgrade.UpgradeDBUtil.initDataSource(UpgradeDBUtil.java:207)
 at com.sygate.scm.server.upgrade.ui.Main.<init>(Main.java:93)
 at com.sygate.scm.server.upgrade.ui.Main.main(Main.java:221)
Result: Can't connect to database at this moment. You may need to upgrade manually.
com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:833)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:804)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:839)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:866)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:249)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:287)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:1429)
 at com.sygate.scm.server.upgrade.ui.Main.<init>(Main.java:115)
 at com.sygate.scm.server.upgrade.ui.Main.main(Main.java:221)
Caused by: java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
 at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:188)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:137)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:285)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:276)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:831)
 ... 8 more
com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:833)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:804)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:839)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:866)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:249)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:287)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:1429)
 at com.sygate.scm.server.upgrade.ui.Main.<init>(Main.java:115)
 at com.sygate.scm.server.upgrade.ui.Main.main(Main.java:221)
Caused by: java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
 at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:188)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:137)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:285)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:276)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:831)
 ... 8 more
java.lang.ClassNotFoundException: com.sygate.scm.util.i18n.ErrorMsg_en_GB
 at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
 at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
 at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
 at java.lang.Class.forName0(Native Method)
 at java.lang.Class.forName(Class.java:169)
 at com.sygate.scm.util.ErrorMsg.setLocale(ErrorMsg.java:224)
 at com.sygate.scm.util.ErrorMsg.<clinit>(ErrorMsg.java:217)
 at com.sygate.scm.server.util.ServerException.getMessage(ServerException.java:47)
 at java.lang.Throwable.getLocalizedMessage(Throwable.java:267)
 at java.lang.Throwable.toString(Throwable.java:343)
 at java.lang.String.valueOf(String.java:2826)
 at java.io.PrintStream.println(PrintStream.java:771)
 at java.lang.Throwable.printStackTrace(Throwable.java:461)
 at com.sygate.scm.server.util.ServerException.printStackTrace(ServerException.java:79)
 at java.lang.Throwable.printStackTrace(Throwable.java:451)
 at com.sygate.scm.server.util.ServerException.printStackTrace(ServerException.java:72)
 at com.sygate.scm.server.upgrade.ui.Main.<init>(Main.java:128)
 at com.sygate.scm.server.upgrade.ui.Main.main(Main.java:221)
com.sygate.scm.server.util.ServerException: Unexpected server error.
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:329)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:1429)
 at com.sygate.scm.server.upgrade.ui.Main.<init>(Main.java:115)
 at com.sygate.scm.server.upgrade.ui.Main.main(Main.java:221)
Caused by: com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:833)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:804)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:839)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:866)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:249)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:287)
 ... 3 more
Caused by: java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
 at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:188)
 at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:137)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:285)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:276)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:831)
 ... 8 more
Launch FRame
Failed to get the server version from the database. null

Hi,


This seems to be an issue with ODBC connection to the SQL database.
Most probably incorrect login info for the dba admin password.


Verify communication to the Remote (SQL) Database.

• Verify that you have specified a named instance during installation and configuration. Example: \\<server name>\<instance name>
• Verify SQL Server is running and properly configured.
• Verify the network connections between Symantec Endpoint Protection Manager and the SQL database.
• Test the ODBC connection.
  1. Click Start> Control Panel
  2. Open Administrator Tools
  3. Double-click Data Sources (ODBC)
  4. Select the System DSN tab
  5. Double-click SymantecEndpointSecurityDSN and go through the wizard to ensure the following settings:
     • Name: SymantecEndpointSecurityDSN
     • Description: <Anything>
     • Server: Servername\InstanceName (Only enter the server name or IP address if using the default instance)
     • Login ID: sa
     • Password: <password>
        
  6. Leave the defaults for the rest of the items and click Finish
  7. Click Test Data Source on the next page and ensure it states "Success"
  8. Click OK
  
  
  For 64bit ODBC communication follow the link below.

http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008021900094548


Please go to the tools folder in SEPM and run the dbvalidator tool.

The logfile of the tool will be in the sepm\tomcat\logs folder.

Regards,
Aniket Amdekar

Hi, yes it was using Windows authentication.  I though the SEP sql account would have had sufficient right.  Thanks for your help.