How to install CostOS
with minimum DB privileges

This guide can show you how to install CostOS with just dbowner role for databases and public for database server.
First you need to have two empty databases, with the second one named after the concatanation of the first database's name plus 'ProjectDatabase' (e.g.CostOS, CostOSProjectDatabase). To do so, please log in on Management Studio with the credentials of a user that can do the above, right click on the folder 'Databases' on the instance that opens and go for 'New Database'. Name it, click 'OK' and repeat for 'ProjectDatabase'.
Then you have to create the user that will manage CostOS data. To do so, right click on the Security folder, select 'New' and then 'Login'. On the window that opens, give a simple name(e.g. Costos), switch to 'SQL Server Authentication' & then insert and confirm password. Switch to page 'Server Roles' and make sure the 'public' role has been assigned. Click on OK.
What remains now is to get the user to have access to CostOS databases. To do so, open up the first CostOS database you created. Right click on 'Security', seleect 'New' and then 'User...' . Fill in the top two blanks with the name of the CostOS user – you may click to browse for available for the second blank to avoid spelling errors. For the third one, click on the box to browse and then go for 'Browse...'. From the list that appears, tick 'db_owner', click 'OK' and then switch to page 'Owned Schemas'. Tick 'db_owner' there and repeat for next page too, 'Membership'. Click 'OK'. Now repeat for CostOS project database.
You have finished the custom creation of databases. Now only thing to have in mind is to use this specific SQL user when configuring Database access during installation.




  • No labels