More in this section
Forums / Deployment / Sitefinity SQL Server database creation/admin user

Sitefinity SQL Server database creation/admin user

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
4 posts, 0 answered
  1. Scott
    Scott avatar
    3 posts
    23 Jun 2014
    31 Oct 2014
    Link to this post

    Good morning,

     I'm trying to deploy a Sitefinity application in a development environment where I have limited database access. None of the content or users in the application matter at all - I just want to start from a "blank" site, create an admin user, and go from there. This is all out-of-the-box, nothing customized.

    The first time I scripted the database objects from an existing application. No data, just objects. The new application has the correct connection string for the new database. But I wasn't prompted to create an admin user. The site asked me to log in to the backend, but I never created an admin user so I can't log in.

     Which is preferable, or does it matter: Should I delete and recreate all the database objects and start the app again, or if I just drop all the tables will the application recreate them? Or is there something else I'm missing that will enable me to create an admin user? I don't have the option of manipulating the records in the database directly. 

    The application is in the db_owner role on the database. 


  2. Zornitsa
    Zornitsa avatar
    2 posts
    15 Dec 2015
    21 Nov 2014
    Link to this post
    Hi Scott,

    If you need a new blank application, best approach would be to drop the existing table and create a new one with the application. Alternatively, when creating a new application you can provide an existing blank db in the creation toll and you will be prompted to create an admin user.
    Could you confirm the steps you used for creating the new site? Did you use an existing application and changed the connection string or is the new application created from the sitefinity project manager?

    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 Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
  3. Danny
    Danny avatar
    0 posts
    18 Feb 2014
    22 Jul 2016
    Link to this post
    Have this exact problem and see that no solution was proposed. What is the correct way to handle this? Allowed it to create the tables for a new DB twice now but still no startup page--just keeps asking me to login even though the users table is empty. Help!
  4. Michael
    Michael avatar
    0 posts
    09 Apr 2009
    03 Feb 2017
    Link to this post
    I have this same issue...why don't you guys just give us a blank database as a .bak?  Can anyone from Sitefinity/Progress help me?
4 posts, 0 answered