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...[vbcol=seagreen]
SQL2005[vbcol=seagreen]
upgrade of[vbcol=seagreen]
not sure[vbcol=seagreen]
start[vbcol=seagreen]
|||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:
> "Noah" <noah@.carpathiahost.com> wrote in message
> news:%23CP4Q2C2HHA.4004@.TK2MSFTNGP05.phx.gbl...
> SQL2005
> upgrade of
> not sure
> start
>
|||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...[vbcol=seagreen]
> Also all DB files are currently set at compatibility level of 90.
>
> Noah wrote:
|||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.