About SQL Server database authentication modes
|Article:HOWTO81040|||||Created: 2012-10-24|||||Updated: 2013-10-07|||||Article URL http://www.symantec.com/docs/HOWTO81040|
The Symantec Endpoint Protection Manager supports two modes of SQL Server database authentication:
Microsoft 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, the 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.
Article URL http://www.symantec.com/docs/HOWTO81040