Endpoint Protection

 View Only
Back to discussions
Expand all | Collapse all

configuring SEP with sql database , cannot create database

Migration User

Migration UserFeb 02, 2010 03:25 AM

it is correct only........
Rafeeq

RafeeqFeb 02, 2010 11:52 AM

tried reinstalling sql clients?

  • 1.  configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 01:17 AM


     


    1 ) use an existing Database method

    i was trying to  Installing  and configuring  SEP 11.5  with sql database ( ) and it stuck

    in the database is  being created and initilized .this will take a few minutes , initializing databse ...........
    when 


    infos are below

    Sql server instance =default

    In mangement Server Configuration  Wizard  Selected  Use an existing Database

    file groups defined  for the database (Primary , Fg_content,fg_index,fg_loginfo,fg_rptinfo) 

    database role membership  db_ddladmin,db_datareader,db_datawriter and public by default

    user mapped to  the database

     


    2 ) Create new  database method

    When i choose Create new  database method it ended up in the  Error 11501 :unable to create the database for SEPM


    Sql server  Instance name  SERVERNAME\SEPM

     

    tcp/ip properties  sql server configuration manager in default and   SEPM instances

    IP1

    active : yes
    enabled : yes
    tcp Dynamic Ports :
    tcp port :1433

    IP2

    active : yes
    enabled : yes
    tcp Dynamic Ports :
    tcp port :1433


    sQL SERVER 2005 network configuration

    TCP/IP Enabled in both instance


    OS : WIN2008 ENTERPRISE 32 BIT
    SQL SERVER : SQL 2005 +SP2

     

     

     


     



  • 2.  RE: configuring SEP with sql database , cannot create database

    Broadcom Employee
    Posted Feb 02, 2010 01:21 AM
    for the 2nd Scenerio, this link might be helpful

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


  • 3.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 01:22 AM
    Login to SQL under credentials delete sem5 user and under databases delete sem5 database and try to install SEPM with new database...(I am believing this is a fresh install.)


  • 4.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 02:22 AM
    Thanks Aravind  , its a fresh installation  .Now its creating database .its  gonna take ages........?

    Thank you


  • 5.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 02:28 AM
    It should not take much time.May take 10-15 min. But it depends... Observe and update us...


  • 6.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 03:00 AM

    The process is running around 45 minute , forget to tell  that  Sql server instance   is  default 

    and ip1 is  local ip address

    and ip2 is 127.0.0.1



  • 7.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 03:19 AM
    Where is your SQL locates is it in the same server(The same SEPM server)? Were you are seeing IP1 and IP2? Which is the SQL version?


  • 8.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 03:25 AM
    It s in the same server  not remote

    sql  version is 2005+sp2

    os windows enterprise 2008 32 bit +sp2

    ip1 and ip2   in tcp/ip properties  sql server configuration manager,

    i can see the database files are created  in the folder  like  sql server log, index 


  • 9.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 03:25 AM
    it is correct only........


  • 10.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 03:46 AM

    it seems that it never gonna finish the installation

    Please help



  • 11.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 03:51 AM
    Restart the server ,turn off windows defender,firewall and UAC. Try to install once again...


  • 12.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 03:56 AM
    Best Practices guide for Installing the Symantec Endpoint Protection Manager with a SQL Server 2005 Database http://service1.symantec.com/support/ent-security.nsf/docid/2008031504445748?Open&seg=ent Checklist for installing Symantec Endpoint Protection Manager with SQL Server 2005 http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008052707113348?Open&seg=ent


  • 13.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 10:56 AM
    firewall off, turned off UAC, server restrted,sql uninstalled ,

    Installed sql server again (now only one instance,  instance name server\sep)

    iis role removed and  added role again  as per the documents below

    http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008052707113348?Open&seg=ent


    then tried to nstall SEPM , while installation progressng  got the error below

    "
    To continue  the installation ,make sure that the the IIS world wde web publishing service (w3svc) is installed and running . on computers that run iis 7.0 or later , the following  iis role services must also be installed : asp.net ,cgi,and iis 6.0 Management compatblity .:

    after the asp.net   installed  installation started .


    but  the installaton ended up in " the database is  being created and initilized .this will take a few minutes , initializing databse ..........."

    Anyone  has succeeded in  SEPM +SQL 2005

    server ram :2 gb
    server os "win 2008 ent 32 +sp2
    sql server : sql 2005 +sp2

    Thank you


     





  • 14.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 11:10 AM
    Please paste the .err files found under

    C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\logs
    scm-server-0.log and catalina.out and all .err log..


  • 15.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 11:30 AM


    install_log.err 0 kb

    empty

    install_log.out


    JDBC Driver checked, URL= jdbc:jtds:sqlserver://MFAV01:1433;instance=SEP Driver class= net.sourceforge.jtds.jdbc.Driver
    JDBC Driver loaded.
    DB VERSION 09.00.3042
    Creating new database...
    Creating new database...done.
    Initializing database ...
    execCommandFromScript cmdSeparator;;
    Initializing data ...
    Generating server certificate ...
    Keystore type is: JKS
    Server certificate/ keypair was created successfully ...
    Exporting server certificate ...
    Server's public certificate was exported successfully ...
    File Length is 790
    MIICOzCCAaSgAwIBAgIES2hCnTANBgkqhkiG9w0BAQUFADBiMQswCQYDVQQGEwJVUzELMAkGA1UE
    CBMCQ0ExEDAOBgNVBAcTB0ZyZW1vbnQxFTATBgNVBAoTDHN5bWFudGVjLmNvbTEMMAoGA1UECxMD
    c2NtMQ8wDQYDVQQDEwZNRkFWMDEwHhcNMTAwMjAyMTUxOTU3WhcNMjAwMTMxMTUxOTU3WjBiMQsw
    CQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExEDAOBgNVBAcTB0ZyZW1vbnQxFTATBgNVBAoTDHN5bWFu
    dGVjLmNvbTEMMAoGA1UECxMDc2NtMQ8wDQYDVQQDEwZNRkFWMDEwgZ8wDQYJKoZIhvcNAQEBBQAD
    gY0AMIGJAoGBAMnCIXq+AzyMpEv1Xtotf3XDJhfjBgfAVHhd550MqCgoZqnqZ0doTnKUg63LilTr
    L/E9j8ivA9VKGB8W1MGOztOg4EVbhAODtCOoUOugaFQ5pL1+ek0u1BS1APWLkHH2VUIAUcc3r63B
    DZOM86kds+cCONKN7UCdk1tSUXjrAKINAgMBAAEwDQYJKoZIhvcNAQEFBQADgYEAIFWPlFZrDcg/
    PJBIFNU8u+8nHKCh47rQmV38HoCPsM6RiHJncQ/05ramKyShIBTVhDtuxfHtmeRZhSmoUC7uZmu3
    /ZajxiKTIaP11i3+p+xf41VMnDyjOJwnMdflHoJS5ljz0F47UILQczBliBoC/M0+2Fe0tED34jM5
    68m65CE=

    Protecting server certificate (the keypair file) with ACLs ...


    smbinstall_log.err  0 kb

    empty

    smbinstall_log.out


    Has valid SAV license
    Info>> No SNAC license file in C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\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): 3113851289/536870912
    Checking available disk/memory size(Bytes)...
    Available disk/memory size(Bytes): 20148981760/2146066432
    Saving companySize Panel user settings:
    Company size: 0
    Content revision number:30
    DB backup number: 10
    Starting db configuration process...

     



  • 16.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 11:36 AM
    is this use a existing db or new db?
    or not swap those, place the log file again.


  • 17.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 11:47 AM

    used  Create new  database method

    1 ) install_log.err  and   smbinstall_log.err files are empty 

       
    2  ) items  from  install_log.out are below 

     JDBC Driver checked, URL= jdbc:jtds:sqlserver://MFAV01:1433;instance=SEP Driver class= net.sourceforge.jtds.jdbc.Driver
    JDBC Driver loaded.
    DB VERSION 09.00.3042
    Creating new database...
    Creating new database...done.
    Initializing database ...
    execCommandFromScript cmdSeparator;;
    Initializing data ...
    Generating server certificate ...
    Keystore type is: JKS
    Server certificate/ keypair was created successfully ...
    Exporting server certificate ...
    Server's public certificate was exported successfully ...
    File Length is 790
    MIICOzCCAaSgAwIBAgIES2hCnTANBgkqhkiG9w0BAQUFADBiMQswCQYDVQQGEwJVUzELMAkGA1UE
    CBMCQ0ExEDAOBgNVBAcTB0ZyZW1vbnQxFTATBgNVBAoTDHN5bWFudGVjLmNvbTEMMAoGA1UECxMD
    c2NtMQ8wDQYDVQQDEwZNRkFWMDEwHhcNMTAwMjAyMTUxOTU3WhcNMjAwMTMxMTUxOTU3WjBiMQsw
    CQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExEDAOBgNVBAcTB0ZyZW1vbnQxFTATBgNVBAoTDHN5bWFu
    dGVjLmNvbTEMMAoGA1UECxMDc2NtMQ8wDQYDVQQDEwZNRkFWMDEwgZ8wDQYJKoZIhvcNAQEBBQAD
    gY0AMIGJAoGBAMnCIXq+AzyMpEv1Xtotf3XDJhfjBgfAVHhd550MqCgoZqnqZ0doTnKUg63LilTr
    L/E9j8ivA9VKGB8W1MGOztOg4EVbhAODtCOoUOugaFQ5pL1+ek0u1BS1APWLkHH2VUIAUcc3r63B
    DZOM86kds+cCONKN7UCdk1tSUXjrAKINAgMBAAEwDQYJKoZIhvcNAQEFBQADgYEAIFWPlFZrDcg/
    PJBIFNU8u+8nHKCh47rQmV38HoCPsM6RiHJncQ/05ramKyShIBTVhDtuxfHtmeRZhSmoUC7uZmu3
    /ZajxiKTIaP11i3+p+xf41VMnDyjOJwnMdflHoJS5ljz0F47UILQczBliBoC/M0+2Fe0tED34jM5
    68m65CE=

    Protecting server certificate (the keypair file) with ACLs ...

    3 ) smbinstall_log.out are below


    Has valid SAV license
    Info>> No SNAC license file in C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\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): 3113851289/536870912
    Checking available disk/memory size(Bytes)...
    Available disk/memory size(Bytes): 20148981760/2146066432
    Saving companySize Panel user settings:
    Company size: 0
    Content revision number:30
    DB backup number: 10
    Starting db configuration process...






     



  • 18.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 11:52 AM
    tried reinstalling sql clients?


  • 19.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 02, 2010 01:44 PM
    sql client was uninstalled and it was installed when the sqlsetup run

    what we can understand from the log posted in the previous comment ?


  • 20.  RE: configuring SEP with sql database , cannot create database
    Best Answer

    Posted Feb 03, 2010 12:59 AM
    server ram :2 gb may be the problem can you gut increase it just to 4 gb for testing and try  


  • 21.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 03, 2010 04:31 AM
    Dear Aravind 

    Thanks a lot  , it was just  ram  issue .But  symantec  recommended 2 gb !!!!!!!!!!!!!!!. Anyway i increased ram to 3 gb and formatted  installed wndows server 2008 ent r2  64 bit and sql 2005 + sp3


  • 22.  RE: configuring SEP with sql database , cannot create database

    Posted Feb 03, 2010 04:55 AM
    We have to consider all the things..
      Win2k8, SQL 2005,SEPM  everything will consume good amount of memory...... 

    Happy to hear your problem got solved...