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

Forums / Developing with Sitefinity / Attaching Sitefinity DB to parent instance of SQL Server

Attaching Sitefinity DB to parent instance of SQL Server

2 posts, 0 answered
  1. Duncan Evans
    Duncan Evans avatar
    122 posts
    Registered:
    07 Jul 2009
    13 Apr 2011
    Link to this post
    I would like to attach my Sitefinity databases to the parent instance of SQL Server. However doing so means that my Sitefinity websites loose sysadmin permissions in the process.

    Are there any recommended connection string changes that are recommended by Sitefinity that i need to do if i want to attach my databases to the parent instance?

    Thanks,

    Duncan
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    19 Apr 2011
    Link to this post
    Hello Duncan Evans,

    I can suggest that you use Windows Authentication for connecting to your SQL server if possible (Integrated Security). Then on your SQL server you need to add a login for the identity of your application pool in which your Sitefinity websites run. After you create the login you should assign this user to the db_owner role for your databases.

    Best wishes,
    Radoslav Georgiev
    the Telerik team

2 posts, 0 answered