Just a quick update - I compared the database I want to use to the one I am currently using and I noticed that the one I am currently using has a bunch of umbraco tables but the one I want to use does not. Are these tables created when you install Umbraco and configure the database? Or can you get those tables on the database without re-installing?
That runs as one of the steps when you go to the install folder on your local site. You don't have to do the whole install again, just go to http://yoursite/install/
Thanks a lot for your help. I'm sure it was right on the money but I had already reinstalled and it worked a charm. It really was just the tables on the database that Umbraco creates when you install.
Change database after setup - Invalid object name 'umbracoDomains'.
Hi folks, I have successfully installed Umbraco 4.5 but accidentally set it up with the wrong databse (one currently used for another site).
I tried to change the database connection string (real values substituted):
<add key="umbracoDbDSN" value="server=SERVERNAME;database=DBNAME;user id=DBUSER;password=PASSWORD" />
but when I do I get the following error message.
System.Data.SqlClient.SqlException: Invalid object name 'umbracoDomains'.
Coincidentally, the wrong database is working fine which I am guessing is because it was the one I used to set up the site.
Do I have to change something elsewhere in the web config or the database?
Just a quick update - I compared the database I want to use to the one I am currently using and I noticed that the one I am currently using has a bunch of umbraco tables but the one I want to use does not. Are these tables created when you install Umbraco and configure the database? Or can you get those tables on the database without re-installing?
That runs as one of the steps when you go to the install folder on your local site. You don't have to do the whole install again, just go to http://yoursite/install/
Hi Jeff,
Thanks a lot for your help. I'm sure it was right on the money but I had already reinstalled and it worked a charm. It really was just the tables on the database that Umbraco creates when you install.
Thanks again!,
David.
is working on a reply...