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...
>|||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...
>

Installation fails for SQL Server 2000

I have attempted to install SQL Server 2000 as the default
instance. Maybe, it is because I attempt to install via
Remote Access.
In this way, I terminate the task. However, I am not able
to remove the default instance (That is terminated before)
AND when I attempt to install again, it asks me to create
a new instance.
Would it be possible for me to remove the corrupted
default instance and install it again ?
Thanks
Peter
In Add/Remove programs (Control Panel) you can uninstall SQL Server , can't
you?
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:072701c5b1da$cf5d43f0$a601280a@.phx.gbl...
>I have attempted to install SQL Server 2000 as the default
> instance. Maybe, it is because I attempt to install via
> Remote Access.
> In this way, I terminate the task. However, I am not able
> to remove the default instance (That is terminated before)
> AND when I attempt to install again, it asks me to create
> a new instance.
> Would it be possible for me to remove the corrupted
> default instance and install it again ?
> Thanks
|||Hi,
Restart ur machine and try to unstall sql server.
else u can go to control panal remove /add programes and remove sql
server.
or u can over write a new installation on ur previous installation
hope this helps u
from
doller
|||I am not able to uninstall SQL Server via Remove / Add programmes.
I have attempted to run setup.exe and try the uninstall option but it still
doesn't work.
Thanks
"doller" <sufianarif@.gmail.com> wrote in message
news:1125901237.773629.261220@.g47g2000cwa.googlegr oups.com...
> Hi,
> Restart ur machine and try to unstall sql server.
> else u can go to control panal remove /add programes and remove sql
> server.
> or u can over write a new installation on ur previous installation
> hope this helps u
> from
> doller
>

Installation fails for SQL Server 2000

I have attempted to install SQL Server 2000 as the default
instance. Maybe, it is because I attempt to install via
Remote Access.
In this way, I terminate the task. However, I am not able
to remove the default instance (That is terminated before)
AND when I attempt to install again, it asks me to create
a new instance.
Would it be possible for me to remove the corrupted
default instance and install it again ?
ThanksPeter
In Add/Remove programs (Control Panel) you can uninstall SQL Server , can't
you?
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:072701c5b1da$cf5d43f0$a601280a@.phx.gbl...
>I have attempted to install SQL Server 2000 as the default
> instance. Maybe, it is because I attempt to install via
> Remote Access.
> In this way, I terminate the task. However, I am not able
> to remove the default instance (That is terminated before)
> AND when I attempt to install again, it asks me to create
> a new instance.
> Would it be possible for me to remove the corrupted
> default instance and install it again ?
> Thanks|||Hi,
Restart ur machine and try to unstall sql server.
else u can go to control panal remove /add programes and remove sql
server.
or u can over write a new installation on ur previous installation
hope this helps u
from
doller|||I am not able to uninstall SQL Server via Remove / Add programmes.
I have attempted to run setup.exe and try the uninstall option but it still
doesn't work.
Thanks
"doller" <sufianarif@.gmail.com> wrote in message
news:1125901237.773629.261220@.g47g2000cwa.googlegroups.com...
> Hi,
> Restart ur machine and try to unstall sql server.
> else u can go to control panal remove /add programes and remove sql
> server.
> or u can over write a new installation on ur previous installation
> hope this helps u
> from
> doller
>