+1-888-365-2779
Try Now
More in this section

Forums / Deployment / Which permissions are required on SQL Server

Which permissions are required on SQL Server

4 posts, 0 answered
  1. Jaap
    Jaap avatar
    10 posts
    Registered:
    23 Oct 2012
    19 Sep 2011
    Link to this post
    Hi,

    I want to deploy the Sitefinity database on a SQL Server instance. Which permissions are at least required for the account which will access the database? I can't find it anywhere in the documentation. Is db_datareader, db_datawriter and db_ddladmin enought?

    Thanks, Jaap
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    19 Sep 2011
    Link to this post
    Hi Jaap,

    You need db_owner if you are going to create the database though the Project Manager. Also, when using Forms additional tables are created into the database, so you will need permission for this.

    All the best,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Jaap
    Jaap avatar
    10 posts
    Registered:
    23 Oct 2012
    19 Sep 2011
    Link to this post
    After some tests, it seems to be enough to have the roles I mentioned (when having an exiting database). I can create e.g. a new product type in the ECommerce module. This will create a new table fine.

    Thanks, Jaap
  4. Bill
    Bill avatar
    26 posts
    Registered:
    18 Jul 2012
    15 Aug 2012
    Link to this post
    Is this still accurate for sitefinity 5.x?  I need to get the permissions corrected on the web accounts so I can do the 5.0 to 5.1 upgrades without errors and my DBAs keep trying to fix it with lesser permissions so an authoritative answer would save some time.
4 posts, 0 answered