Error while upgrading SQL2005 Standard To SQL 2005 Enterprise

Hello,
I just recently tried to upgrade a two node SQL2005 Standard to SQL2005
Enterprise. I received the following error message during the upgrade of
the database components.
Product: Microsoft SQL Server 2005 -- Error 29550. The
setup has encountered an error while Upgrading Components.
The error: -2147019873
Error message: The group or resource is not in the correct
state to perform the requested operation.
My customers ASPState Database is in simple recovery mode. I was not
sure if this is what could have caused this error. Also will i have to
start with a fresh install of SQL 2005 to resolve this issue?
Thanks for the help.I doubt that is it. Are any of the files, filegroups or dbs read only or in
other than OnLine mode? Do any of the dbs have a computability level of
less than 80?
--
Andrew J. Kelly SQL MVP
"Noah" <noah@.carpathiahost.com> wrote in message
news:%23CP4Q2C2HHA.4004@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I just recently tried to upgrade a two node SQL2005 Standard to SQL2005
> Enterprise. I received the following error message during the upgrade of
> the database components.
>
> Product: Microsoft SQL Server 2005 -- Error 29550. The
> setup has encountered an error while Upgrading Components.
> The error: -2147019873
> Error message: The group or resource is not in the correct
> state to perform the requested operation.
> My customers ASPState Database is in simple recovery mode. I was not sure
> if this is what could have caused this error. Also will i have to start
> with a fresh install of SQL 2005 to resolve this issue?
> Thanks for the help.|||As far as i am aware all the files, filegroups are not in a read only
mode and all DB files are Online. As far as DB computability level i
will have to look into that.
Andrew J. Kelly wrote:
> I doubt that is it. Are any of the files, filegroups or dbs read only or in
> other than OnLine mode? Do any of the dbs have a computability level of
> less than 80?
>
"Noah" <noah@.carpathiahost.com> wrote in message
news:%23CP4Q2C2HHA.4004@.TK2MSFTNGP05.phx.gbl...
> > Hello,
> >
> > I just recently tried to upgrade a two node SQL2005 Standard to
SQL2005
> > Enterprise. I received the following error message during the
upgrade of
> > the database components.
> >
> >
> >
> > Product: Microsoft SQL Server 2005 -- Error 29550. The
> > setup has encountered an error while Upgrading Components.
> > The error: -2147019873
> > Error message: The group or resource is not in the correct
> > state to perform the requested operation.
> >
> > My customers ASPState Database is in simple recovery mode. I was
not sure
> > if this is what could have caused this error. Also will i have to
start
> > with a fresh install of SQL 2005 to resolve this issue?
> >
> > Thanks for the help.|||Also all DB files are currently set at compatibility level of 90.
Noah wrote:
> As far as i am aware all the files, filegroups are not in a read only
> mode and all DB files are Online. As far as DB computability level i
> will have to look into that.
> Andrew J. Kelly wrote:
>> I doubt that is it. Are any of the files, filegroups or dbs read only
>> or in other than OnLine mode? Do any of the dbs have a computability
>> level of less than 80?
> "Noah" <noah@.carpathiahost.com> wrote in message
> news:%23CP4Q2C2HHA.4004@.TK2MSFTNGP05.phx.gbl...
> > > Hello,
> > >
> > > I just recently tried to upgrade a two node SQL2005 Standard to
> SQL2005
> > > Enterprise. I received the following error message during the
> upgrade of
> > > the database components.
> > >
> > >
> > >
> > > Product: Microsoft SQL Server 2005 -- Error 29550. The
> > > setup has encountered an error while Upgrading Components.
> > > The error: -2147019873
> > > Error message: The group or resource is not in the correct
> > > state to perform the requested operation.
> > >
> > > My customers ASPState Database is in simple recovery mode. I was
> not sure
> > > if this is what could have caused this error. Also will i have to
> start
> > > with a fresh install of SQL 2005 to resolve this issue?
> > >
> > > Thanks for the help.
>|||I just reread your original post. You said "2 node". Is this a cluster? If
so the error is probably talking about the cluster resource group not SQL
Server. Try posting this in the Cluster newsgroup for a better answer.
--
Andrew J. Kelly SQL MVP
"Noah" <noah@.carpathiahost.com> wrote in message
news:et98dKD2HHA.3760@.TK2MSFTNGP03.phx.gbl...
> Also all DB files are currently set at compatibility level of 90.
>
> Noah wrote:
>> As far as i am aware all the files, filegroups are not in a read only
>> mode and all DB files are Online. As far as DB computability level i will
>> have to look into that.
>> Andrew J. Kelly wrote:
>> I doubt that is it. Are any of the files, filegroups or dbs read only or
>> in other than OnLine mode? Do any of the dbs have a computability level
>> of less than 80?
>> "Noah" <noah@.carpathiahost.com> wrote in message
>> news:%23CP4Q2C2HHA.4004@.TK2MSFTNGP05.phx.gbl...
>> > > Hello,
>> > >
>> > > I just recently tried to upgrade a two node SQL2005 Standard to
>> SQL2005
>> > > Enterprise. I received the following error message during the
>> upgrade of
>> > > the database components.
>> > >
>> > >
>> > >
>> > > Product: Microsoft SQL Server 2005 -- Error 29550. The
>> > > setup has encountered an error while Upgrading Components.
>> > > The error: -2147019873
>> > > Error message: The group or resource is not in the correct
>> > > state to perform the requested operation.
>> > >
>> > > My customers ASPState Database is in simple recovery mode. I was not
>> sure
>> > > if this is what could have caused this error. Also will i have to
>> start
>> > > with a fresh install of SQL 2005 to resolve this issue?
>> > >
>> > > Thanks for the help.|||Andrew J. Kelly wrote:
> I just reread your original post. You said "2 node". Is this a cluster? If
> so the error is probably talking about the cluster resource group not SQL
> Server. Try posting this in the Cluster newsgroup for a better answer.
>
Will Do thanks.