Endpoint Protection

 View Only
  • 1.  Need Help Changing Database User

    Posted Aug 24, 2016 12:34 PM

    We are using MSSQL for our Symantec Endpoint Protection database.  The user that setup our installation is subject to password change policy, so I would like to change the user to be a service account in Active Directory that does not have password expiration rules.

    In the SEPM database settings, it does not appear that there is a place to change the database user.  How can I do that?



  • 2.  RE: Need Help Changing Database User
    Best Answer

    Posted Aug 24, 2016 12:37 PM

    This would need to be done on the DB on the SQL box. Once that is done you would need to run the Management Server Configuration Wizard to re-configure.

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



  • 3.  RE: Need Help Changing Database User

    Broadcom Employee
    Posted Aug 24, 2016 03:14 PM

    Hi,

    Thank you for posting your query on Symantec community.

    1. Open the Microsoft SQL Server Management Studio and log in to the target SQL instance as an sa equivalent user.
    2. Expand Security in the Object Explorer pane.
    3. Right-click on Logins and click New Login.
    4. Enter the desired name in the Login name field.
    5. Configure the Authentication settings:
      1. Select the SQL Server authentication radio button if you do not require Windows Authentication.
        1. Provide the SQL authentication password and password confirmation.

          Note: The password may contain the characters ~#%_+=|:./ but not the characters `!@$^&*()-{}[]\\<;>,?
        2. Uncheck user must change the password at next login.
      2. Select the Windows authentication radio button if you require Windows Authentication.
    6. Select the SEPM database from the Default database drop-down box (e.g. sem5).
    7. Click the User Mapping page.
      1. Check the SEPM database (e.g. sem5) on the Users mapped to this login section.
      2. Check db_owner in the Database role memberships section.

        Note: Do not uncheck public.
         
    8. Click OK to create the user.

    Untitled_9.jpg

    Refer this guide: http://www.symantec.com/docs/TECH192646