WebMatrix on asphostportal.com

Jun 22, 2015 at 6:15 AM
I have tried to publish my app on asphostportal.com server. After some initial problems I managed to get to login window. Now server is reporting this issue when I try to login:

Invalid object name 'dbo.UserProfile'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.UserProfile'.

I use WebMatrix integrated web security in application, so it should create some security tables e.g. dbo.UserProfile automatically on first application run. I have also granted all privileges to WebMatrix package in settings.

*Note: This app is already published on Azure and works flawlessly.

Jun 22, 2015 at 7:43 PM
Edited Jun 22, 2015 at 7:45 PM
Really hard to tell without looking at db etc.
Lucky guess check db schema and make sure it is actually DBO ('dbo.UserProfile'. ) not something else ex. db_username.UserProfile