When I try to install on my remote host, i get the following error.
[SqlException: EXECUTE permission denied on object 'UpdateDatabaseVersion', database 'Newmark_DotNetNuke', owner 'dbo'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +194
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
DotNetNuke.Data.SqlDataProvider.UpdateDatabaseVersion(Int32 Major, Int32 Minor, Int32 Build) +144
DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +896
DotNetNuke.Framework.Install.InstallApplcation() +211
DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +221
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750 |
So, I assumed it was at it says a permissions problem with the UpdateDatabaseVersion stored procedure.
And Sure enough that user does not have permission to run that stored procedure.
So where's the problem you say!
Well the problem is that this is not my SQL server, it's my ISPs, when I create databases I do so through a portal on my domain account. When I log in using enterprise manager, I have some control over permissions but not total control. My User is not a member of the db_owner role, and this particular stored procedure is, for some reason one of a selected few whose permissions I cannot alter.
I have contacted my ISP, and I am waiting on them to get back to me, however, I have serious doubts that they will allow me to have control of the db_owner.
Any Suggestions
Thanks,
Gerry Canning.