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
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.
SQL Server 2005 SP2
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.