Probably a stupid question, but how come I can't select a database on install?!
So I am trying to publish a site for the first time... I have installed Umbraco using WebMatrix. I created a blank database on my server and created a user for that database. I was expecting to select that database on Step 3 of the install. I've seen on tutorials where you "select the best database option for you". However, I get no options on this stage. Instead I get an update to the latest umbraco which completes and continues to step 4. I have no choices to choose a different database or anything. I'm sure I'm doing something dumb, but I can't figure out what it could be. Does anyone have any suggestions?
What type of blank database did you create? Did you create this in the initial install step? What version of Umbraco are you using? Was it upgraded by you or is it a fresh install? Normally on initial install you will have the option to select your type of database. This sounds like it was an upgrade, in which case the db connection string may already be configured in the web.config. Did you check if it's configured?
I created a blank SQL Server Database. I did not create on the initial install step, or at least I didn't mean to. I may have by mistake. I'm using the latest umbraco version and it is a fresh install. Everything works fine on my localhost, but when I move it to the server I can not login. I'm assuming it's because my connectionstring is not correct in my web.config. Shouldn't I be able to point to the SQL Server Database before moving it to the server?
If you tried moving an existing website onto a server with a blank database, then you have no user info to login with.
If you moved an entire site database and all from localhost to a server, (and you're using MS SQL) then you need to at least delete and recreate the user for your connection string to work.
You're right. I guess my problem is not having any user info to login with like you were saying. Before I tried manually creating the DB, I installed Umbraco using WebMatrix and used a SQL Express database that was created automatically during installation. Then I published the website through WebMatrix using FTP connection. I was able to get to the login screen but my login info never worked. Would I need to manually move the database to the server after I publish for it? Or what could I be missing?
Is it SQL CE? If it is and you have the .sdf in your app_data folder you should be fine. Did you make sure IIS has permission to access your umbraco site folder?
To move an existing site from local to a server you just move the site files, backup and restore the DB from local to your server (make sure to delete and recreate your user), set the permissions on your servers folders.
Probably a stupid question, but how come I can't select a database on install?!
So I am trying to publish a site for the first time... I have installed Umbraco using WebMatrix. I created a blank database on my server and created a user for that database. I was expecting to select that database on Step 3 of the install. I've seen on tutorials where you "select the best database option for you". However, I get no options on this stage. Instead I get an update to the latest umbraco which completes and continues to step 4. I have no choices to choose a different database or anything. I'm sure I'm doing something dumb, but I can't figure out what it could be. Does anyone have any suggestions?
What type of blank database did you create? Did you create this in the initial install step? What version of Umbraco are you using? Was it upgraded by you or is it a fresh install? Normally on initial install you will have the option to select your type of database. This sounds like it was an upgrade, in which case the db connection string may already be configured in the web.config. Did you check if it's configured?
Ken- Fyin.com
Thanks for your reply Ken!
I created a blank SQL Server Database. I did not create on the initial install step, or at least I didn't mean to. I may have by mistake. I'm using the latest umbraco version and it is a fresh install. Everything works fine on my localhost, but when I move it to the server I can not login. I'm assuming it's because my connectionstring is not correct in my web.config. Shouldn't I be able to point to the SQL Server Database before moving it to the server?
I'm a bit confused. Did you try to move the database from local to the server as well?
If you do that, you have to delete and recreate the user info for that DB in SQL as well.
Hi Rob,
No, I manually created the DB on the server.
Eric
Still a bit confused.
If you tried moving an existing website onto a server with a blank database, then you have no user info to login with.
If you moved an entire site database and all from localhost to a server, (and you're using MS SQL) then you need to at least delete and recreate the user for your connection string to work.
You're right. I guess my problem is not having any user info to login with like you were saying. Before I tried manually creating the DB, I installed Umbraco using WebMatrix and used a SQL Express database that was created automatically during installation. Then I published the website through WebMatrix using FTP connection. I was able to get to the login screen but my login info never worked. Would I need to manually move the database to the server after I publish for it? Or what could I be missing?
Is it SQL CE? If it is and you have the .sdf in your app_data folder you should be fine. Did you make sure IIS has permission to access your umbraco site folder?
It's just SQL not SQL CE, but I can go back and make it SQL CE. I haven't done anything with IIS.
To move an existing site from local to a server you just move the site files, backup and restore the DB from local to your server (make sure to delete and recreate your user), set the permissions on your servers folders.
I don't know how to do it via webmatrix and FTP
And make sure NETWORK SERVICES permissions for some folders and the SQL server allow to use Network to login.
when create user in db make sure uncheck the change password first login
is working on a reply...