Endpoint Protection

 View Only

  • 1.  Domain user or SQL user on SQL DB for SEPM

    Posted Dec 21, 2014 04:03 AM

    Hi,

    I have SQL Cluster and i am using Domain User for authentication, so is it the best practice or i should create a new sql user and use it.

    Thanks



  • 2.  RE: Domain user or SQL user on SQL DB for SEPM

    Posted Dec 21, 2014 04:08 AM

    See this

    Ensure that you have an Administrator account that has "sysadmin" privileges on the SQL server in order to create the database.

    How to install the Symantec Endpoint Protection Manager using Windows Authentication and SQL Server 2008

    Article:HOWTO36029 | Created: 2010-11-10 | Updated: 2014-08-18 | Article URL http://www.symantec.com/docs/HOWTO36029


  • 3.  RE: Domain user or SQL user on SQL DB for SEPM

    Posted Dec 21, 2014 08:44 AM
    You can use either as long as they have privs to write to the DB.


  • 4.  RE: Domain user or SQL user on SQL DB for SEPM

    Posted Dec 21, 2014 09:52 AM

    you can use whatever is feasible for you, these are the rights that should be taken care off

    Creating a custom SQL database and user for Symantec Endpoint Protection Manager 11

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


  • 5.  RE: Domain user or SQL user on SQL DB for SEPM

    Posted Dec 22, 2014 05:42 AM

    I'd personally recommend Windows auth, as it's more secure:

    http://msdn.microsoft.com/en-GB/library/ms144284.aspx

    But it really is up to you...



  • 6.  RE: Domain user or SQL user on SQL DB for SEPM

    Posted Dec 22, 2014 06:20 AM

    You can either use windows/SQL.. But I have seen some issues with the reporting when windows auth is used...