In Website > ASP.net Configuration, the following error occurs,
The EXECUTE permission was denied on the object
'aspnet_CheckSchemaVersion', database 'MyDBName', schema 'dbo'.
My hosting service provider says they do not give DBO permission.
Local Computer has Visual Studio 2008 installed
Shared Hosting Account has Windows 2003
Shared Hosting Database account has MSSQL Server 2005 (REMOTE DB SERVER)
Following are the steps that I did.
1) Created a new Website on Visual Studio (VS)
2) From VS Command Prompt I ran aspnet_regsql
3) I entered the IP of the remote databse server, username, password and Database Name
4) Logged into the remote DB server and could find the appropriate tables are created (11 tables)
eg
dbo.aspnet_aplications
dbo.apsnet_users, etc...
5) In web.config of the local computer
Go to the complete details ...