Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

SEPM and SQL 2005 Config

Updated: 21 May 2010 | 5 comments
daveinspace's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

Hi Guys

I have a fairly straightforward couple of questions that hopefully you can help clarify. I have read alot of the documentation online in the knowledge base but it is not clear, my question is

Is the recommended method to create a Custom SQL DB [1] or let the SEPM installation Wizard create the DB for you?  My SQL 2005 server is remote from the SEPM Console.

Will the Install wizard configure the DB and create all the relevent SQL Filegroups?

Also If i choose to manually create my SQL DB as per the instructions [1], then what do i do during the installwizard onthe SQL config screen?

Thanks for your help!

[1] http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008052215175648

Comments

snekul's picture
20
Oct
2009
1 Vote +1
Login to vote

Are you talkinig about

Are you talkinig about letting SEPM create its own internal database or an SQL database?  Also, how many clients are you looking to manage?  If its under 5,000, the integrated database will probably do just fine.

You might check out service1.symantec.com/support/ent-security.nsf/854fa02b4f5013678825731a007d06af/8ed22363812c4c8388257456004df257

Eric C. Lukens IT Security Policy and Risk Assessment Analyst University of Northern Iowa

daveinspace's picture
20
Oct
2009
0 Votes 0
Login to vote

Thanks for the link had not

Thanks for the link had not seet that one yet!

I am going to use SQL. I am talking about whether to create my own custom SQL DB or let let the SEPM install wizard create this for me, which is preferred method? Create the DB manually and specify it in the Wizard ?? Clients will be under 5000 but we are going with SQL anyway.

Thanks

sandip_sali's picture
20
Oct
2009
1 Vote +1
Login to vote

SEPM and SQL 2005

Is the recommended method to create a Custom SQL DB [1] or let the SEPM installation Wizard create the DB for you?  My SQL 2005 server is remote from the SEPM Console.    The prefered option is let the SEPM install wizard create this for you unless you have some database which has a similar name or instance.

In case its a 64 bit machine please follow this link      http://service1.symantec.com/SUPPORT/ent-security....

Thanks & Regards Sandip C Sali

shp's picture
20
Oct
2009
1 Vote +1
Login to vote

The best way is to let the

The best way is to let the SEPM installation Wizard create the DB for you...

It creates a DB, user and its tables type. Permission and other things will be taken care...

Once the db is created, you can modify it in MS SQL Management console(You can moved the database files, you can add a log files etc....)

Regards,
Srinivas H.P.
HCL Infosystems Ltd

daveinspace's picture
20
Oct
2009
0 Votes 0
Login to vote

Thanks I went with the wizard

Thanks I went with the wizard and the sql DB created looks fine. My query was really just to ascertain if the wizard would do the same steps as the custom setup instructions.