Hello,

I have a GoDaddy shared hosting account.  I'm trying to upgrade my DNN instance from 7.03.04 to 7.04.00 and I'm getting the following error:

25% ERROR occured -
System.Data.SqlClient.SqlException (0x80131904): User does not have permission to alter database 'OBibleStudy', the database does not exist, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at
System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:72502b16-b489-4167-ba29-d484e67af68a Error Number:5011,State:9,
Class:14
 /************************************************************/
 /***** SqlDataProvider *****/
 /***** *****/
 /***** *****/
 /***** Note: To manually execute this script you must *****/
 /***** perform a search and replace operation *****/
 /***** for dbo. and *****/
 /***** *****/
 /************************************************************/
 /***** DNN-6159: update database compatibility to sql 2008 when its below than 2008. *****/
DECLARE @ProductEdition INT
SET @ProductEdition = CAST(ServerProperty('EngineEdition') as INT)

IF (@ProductEdition <> 5)
BEGIN
 DECLARE @Name NVARCHAR(260), @CompatibilityLevel INT
 SELECT @Name = DB_NAME()
 SELECT @CompatibilityLevel = compatibility_level FROM sys.databases WHERE name = @Name
 
 IF @CompatibilityLevel <= 100
 BEGIN
  DECLARE @sql NVARCHAR(max)
  SELECT @sql = N'ALTER DATABASE [' + @Name + '] SET COMPATIBILITY_LEVEL = 100'
  EXECUTE sp_executesql @sql
 END
END

It seems that it's having trouble with the "ALTER Database" statement.  Do I need any special permissions for this?

This is happening on 2 of my hosting accounts...  Any help would be apperciated.

Thanks!

Fady

Thanks for the quick response.  The account has permissions since I was able to do an alter table statement.  I also called the GoDaddy support and they verified that the account is a db owner.  Do I need root permissions to do an Alter Database statement?

I noticed that this is the first DNN Upgrade ever that has an ALTER DATABASE sql statement.  Perhaps this requires extra privileges that I don't have?

In my case the database COMPATIBILITY_LEVEL was already set to 100.  I modified the upgrade script to take out this section only and tried again and it seemed to work for me.

Thanks again for the help!