installing 2005 over 2000

I tried to install 2005 and chose the option to upgrade my existing default
instance. Then it errored out saying, I think, that I need to apply
service packs to my existing 2000 instance.
Why would I need to upgrade something I'm installing over?
Would I be better off just to uninstall 2000, install 2005 and attach all of
my .mdf databases?
Thanks,
TTina,
SQL 2005 will upgrade an existing SQL 2000 instance, but your SQL 2000
instance must be at SP3 or higher. Based on this and your earlier question,
I suggest loading the client tools only for SQL 2005 and doing some reading.
For example, you should really run the upgrade advisor against your existing
database servers to see if there may be any compatibility issues.
The good thing about an upgrade is it keeps all your logins and other
objects in place.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
news:eiTHreqhGHA.4864@.TK2MSFTNGP03.phx.gbl...
>I tried to install 2005 and chose the option to upgrade my existing default
>instance. Then it errored out saying, I think, that I need to apply
>service packs to my existing 2000 instance.
> Why would I need to upgrade something I'm installing over?
> Would I be better off just to uninstall 2000, install 2005 and attach all
> of my .mdf databases?
> Thanks,
> T
>|||I ran the upgrade advisor and it didn't flag any thing about not having the
latest service packs so I thought I was ok. It was only the real install
that flagged that. I guess the advisor doesn't adivse on everything.
T
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23vWfOxqhGHA.3496@.TK2MSFTNGP04.phx.gbl...
> Tina,
> SQL 2005 will upgrade an existing SQL 2000 instance, but your SQL 2000
> instance must be at SP3 or higher. Based on this and your earlier
> question, I suggest loading the client tools only for SQL 2005 and doing
> some reading. For example, you should really run the upgrade advisor
> against your existing database servers to see if there may be any
> compatibility issues.
> The good thing about an upgrade is it keeps all your logins and other
> objects in place.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
> news:eiTHreqhGHA.4864@.TK2MSFTNGP03.phx.gbl...
>>I tried to install 2005 and chose the option to upgrade my existing
>>default instance. Then it errored out saying, I think, that I need to
>>apply service packs to my existing 2000 instance.
>> Why would I need to upgrade something I'm installing over?
>> Would I be better off just to uninstall 2000, install 2005 and attach all
>> of my .mdf databases?
>> Thanks,
>> T
>|||The advisor looks at internal objects in each database. I suppose it should
warn about the server level as well.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
news:%23ymip2yhGHA.1000@.TK2MSFTNGP04.phx.gbl...
>I ran the upgrade advisor and it didn't flag any thing about not having the
>latest service packs so I thought I was ok. It was only the real install
>that flagged that. I guess the advisor doesn't adivse on everything.
> T
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23vWfOxqhGHA.3496@.TK2MSFTNGP04.phx.gbl...
>> Tina,
>> SQL 2005 will upgrade an existing SQL 2000 instance, but your SQL 2000
>> instance must be at SP3 or higher. Based on this and your earlier
>> question, I suggest loading the client tools only for SQL 2005 and doing
>> some reading. For example, you should really run the upgrade advisor
>> against your existing database servers to see if there may be any
>> compatibility issues.
>> The good thing about an upgrade is it keeps all your logins and other
>> objects in place.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
>> news:eiTHreqhGHA.4864@.TK2MSFTNGP03.phx.gbl...
>>I tried to install 2005 and chose the option to upgrade my existing
>>default instance. Then it errored out saying, I think, that I need to
>>apply service packs to my existing 2000 instance.
>> Why would I need to upgrade something I'm installing over?
>> Would I be better off just to uninstall 2000, install 2005 and attach
>> all of my .mdf databases?
>> Thanks,
>> T
>>
>