Let me elaborate a bit on the what exactly happens when a Sitefinity project is being created. At first, when you click on Create new project, main project files are created. If you then explore the project, you'll see for yourself that its folder contains nothing more than the application and few additional files needed for running the project in Visual Studio. At this step the only existing configuration file is the ProjectConfig, which contains basic information about the project. Right after that you are asked to setup the data configuration, which is done by opening the project in a browser and filling up the required fields. As far as I understand, on this step you didn't choose SQLExpress as a server, which means that your database has been created in the folder system of the other server you chose to use. This is actually one of the differences between SQLExpress and Microsoft SQL server, which I wanted to note. When you're using SQL Express the database is created in the App_Data folder, not the server directory. So this means that if you have a project, which was initially configured to use Microsoft SQL server and you want to move ti to SQLExpress, you need to move the database in the App_Data directory and change the data source in the connection string. Here's a connection string of a project that is on SQLExpress:
"Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Sitefinity.mdf"
Also, can you provide a little more information on your scenario. What do you mean by: "cannot find the server at config time
You mentioned that you deleted the config files. If you do that, when running the project in browser you will be asked to setup the data config again, which will allow you to choose SQLExpress as a server, but you will also be required to create a new database. Does this suit your scenario?
As for creating a new user with the role of an administrator, you can do that from the code behind of an aspx page. Take a look at the following code sample:
var userManager = UserManager.GetManager(
var user = userManager.CreateUser(
RoleManager roleManager = RoleManager.GetManager(
var role = roleManager.GetRole(
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