About SQL Server database authentication modes

Article:HOWTO81040  |  Created: 2012-10-24  |  Updated: 2014-09-21  |  Article URL http://www.symantec.com/docs/HOWTO81040
Article Type
How To


Subject


About SQL Server database authentication modes

The Symantec Endpoint Protection Manager supports two modes of SQL Server database authentication:

  • Windows Authentication mode

  • Mixed mode

SQL Server can be configured to use either Windows Authentication or mixed mode authentication. Mixed mode authentication allows the use of either Windows or SQL Server credentials. When SQL Server is configured to use mixed mode, Symantec Endpoint Protection Manager may be set to use either Windows Authentication or mixed mode authentication. When SQL Server is set to use Windows Authentication mode, Symantec Endpoint Protection Manager must also be configured to use Windows Authentication mode.

For the remote database connections that use the Windows Authentication mode, be aware of the following requirements:

  • For deployments in an Active Directory environment, Symantec Endpoint Protection Manager and SQL Server must be located in the same Windows domain.

  • For deployments in a Workgroup environment, the Windows account credentials must be the same for the local computers and the remote computers.

See About SQL Server configuration settings.


Legacy ID



v52562814_v81626096


Article URL http://www.symantec.com/docs/HOWTO81040


Terms of use for this information are found in Legal Notices