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 |
Problem
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
Thank you.