Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 5.x > Installation and deployment > MS SQL security/setup View modes: 
User avatar
Member
Member
crsmith-epri - 7/24/2011 2:25:53 PM
   
MS SQL security/setup
Is there additional information available, in context to KenticoCMS, about installing MSSQL (2008 R2)with minimal permissions? For example, should NETWORK SERVICE ever be used or should a separately created local user account with minimal permissions be used and what minimal permissions could be used?

I'd like to lock down the server as much as possible.

Thx.

User avatar
Kentico Developer
Kentico Developer
kentico_ivanat - 7/25/2011 2:15:57 AM
   
RE:MS SQL security/setup
Hi,

in general it is more secure to create a custom user account. It should be sufficient to add a user into appropriate group. On Win7 the name of group is IIS_IUSRS. For more details please take a look here:
.NET required ACL

Best regards,
Ivana Tomanickova