What privileges are required on SQL Server for Existing databases when user context for the installation of the Application Server component and Application Server Service are different

Article:TECH185375  |  Created: 2012-03-30  |  Updated: 2012-03-30  |  Article URL http://www.symantec.com/docs/TECH185375
Article Type
Technical Solution


Issue



What privileges are required on SQL Server for Existing databases when user context for the installation of the Application Server component and Application Server Service are different


Environment



CCS 10.5.1

SQL Server 2005 SP2


Solution



  • Create the empty databases - CSM_DB , CSM_Reports, CSM_EvidenceDB ( Case sensitive )
  • Assign the db_owner and dbo rights to the user in whose context the component is installed and the service is executed
  • You also must assign the following permissions to the added user through the securables option:

Alter , Control, Impersonate, View Definition permissions.

These user privileges also depend whether the SQL server is in the Windows authentication mode or the SQL authentication mode. The user privileges are same for the single setup of installation and the distributed setup mode of installation.

 

 




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


Terms of use for this information are found in Legal Notices