Invalid Object Name error 0x80131904

Question

User1762885188 posted

Hello all,

I have this error for 2 weeks and I couldn't solve it and I read this post that may start solving from it

http://our.umbraco.org/forum/getting-started/installing-umbraco/24591-Invalid-object-name-%27umbracoDomains%27

My database is working in my localhost perfectly with no errors but when I convert it BAK file and upload it to ixwebhosting I faced this error

please help me to share all posts

Thanks

Answer 1

User1555830864 posted

check this link this may help you out

http://stackoverflow.com/questions/5374482/sqlexception-0x80131904-invalid-object-name-dbo-categories

Answer 2

User1762885188 posted

Hi praseTech,

I read this post before and I am sure of that perhapses or suggestions.

thank you

Answer 3

User-255593050 posted

Hi. When you do your database backup to make you BAK version, are you selecting a 'Full' backup setting?

If you are using the 'Full' backup setting, then can you check the database on the provider to ensure all the tables ands stored procedures have been created? Your error indicates that your SQL code is calling a Table or Stored Procedure that is missing in the provider database.

One last thing, have you checked the connection string, because your local string would refere to ./SQLExpress or similar, whereas on the provider, it will need to point to PROVIDERDATABASENAME/SQLExpress or PROVIDERDATABASENAME/SQLServer.

Hope that helps.