Can you discribe your problem in more detail.

Hi Yobo,

At which point do you get this Error, Is the installation rolling back or you are not able to create Database.

If it is Database, which version of SQL are you using. If SQL 2005 does it have SP2 and if SQL 2000 does it have SP4.

Below are few Articles

How to find out what version, edition, and service pack of SQL Server is installed
Link: http://service1.symantec.com/SUPPORT/ent-security....

Best Practices guide for Installing the Symantec Endpoint Protection Manager with a SQL Server 2005 Database
Link: http://service1.symantec.com/support/ent-security....

Best Practices guide for Installing the Symantec Endpoint Protection Manager with a SQL Server 2000 Database
Link: http://service1.symantec.com/support/ent-security....

Error: "Failed to connect to the database. Please make sure the database server port is not used by another application and that your password is correct."
Link: http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008060323144748

You can check these link and see if this helps.

Hi,

I'm using SQL 2005 SP3.

i got the error on the Management Configuration Wizard.  It is the place where it promot you for  SQL Server, database name, User authenticaiton.

Question is that should it used sem5 or can it be another name for SQL database.

Thanks

Sem5 is just a name that SEPM creates, you can use a different username.
 

Hi Yobo

In the dump file you upload, we can see problem happen when you creating database, SEM5 is defult database name creating when install SEPM, please check your Database is working well or SEM5 is already there.
if there is no other application using your SQL 2005 SP3, try to reinstall SQL may solve this problem.
before take any action, consult Symantec tech support or your DBA firstly.

Ivan 

You can use any name you want.
if still it fails then you can check more details under the install err.log under C:\Program files\Symantec\Symantec Endpoint Protection Manager\Tomcat\Logs

You can also take a look at SEPM_INST.log which can be found in
start type %temp% in run, after open %temp% folder, you can see SEPM_INST.log. wish this install log can help also

U can use any name for user and database.

If u have tried installation more that once, login to sql server management studio and delete sem5 database and user(If database is not having any data)

go to MS sql data(inside Program files)  folder and make sure there are no files with the name sem5.

Then try to reconfigure sepm.

Dear Partner,

Error encounteed at  after I reinstall again.

Create a system administrator account. The password will be required to log to the managemetn console. This password will be required if you have install optional enforcer application.

Initalization of the database failed.
A log file has been generated in the following location c:\Program Files\Symantec\Symantec Endpoint Proection Manager\tomcat\logs\install_Log.err

SQL Exception:
SQL Command: CREATE TABLE PROCESS_STATE( ID char(32) NOT NULL CONSTRAINT PK_PROCESS_STATE PRIMARY KEY NONCLUSTERED ON FG_INDEX, TYPE varchar(256) NOT NULL, STATUS int NOT NULL, TIME_STAMP bigint NOT NULL, UPDATE_OWNER varchar(255) NULL)ON [PRIMARY]
SQLState: S1000
Message: Invalid filegroup 'FG_INDEX' specified.
Vendor: 1921
java.sql.SQLException: Invalid filegroup 'FG_INDEX' specified.
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.getMoreResults(TdsCore.java:620)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:483)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:445)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:623)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1042)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:999)
at com.sygate.scm.install.ui.MainFrame.initDatabase(MainFrame.java:1924)
at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1233)
at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:835)
at com.sygate.scm.install.ui.MainFrame.access$400(MainFrame.java:184)
at com.sygate.scm.install.ui.MainFrame$3$1.construct(MainFrame.java:618)
at com.sygate.scm.install.util.SwingWorker$2.run(SwingWorker.java:121)
at java.lang.Thread.run(Thread.java:595)

Are you trying to use any existing Databse in SQL for SEPM?

Yes, I am.

I think i know the reason. I created manually but did not create the rest of the required files.

Thanks

Please go through the Installation Guide present in Documentaion folder of CD1 and you will be able to find out more on this.

Search for "'FG_INDEX" in that file, there it explains about using existing database.