Pete wrote:
> I am trying to upgrade my SQL 2000 reporting service database to 2005. I am
> following the direction outlined in SQL Server 2005 Books online, article
> number 143724, Migrating reporting Services. When I try to upgrade my
> reporting service database I receive the following error, when Upgrading
> ther Reporting Services database
>
> System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because
> column 'ExecutionType' does not exist in table 'SessionData'.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
> connectionString, String script)
>
> I have applied SP1 to the 2005 installation. I am setup a named instance on
> the 2005 server and am not using the default virtual directories for the 2005
> setup. The 2000 server I am migrating from is version 8.00.760 and the
> version of the Reporting Service is 8.00.1038.00. Any help in identifing
> this issue would be greatly appreciated.
>
> Thanks
> Pete