2005 Create new instance, replace sqlexpress

I had installed Sql Express on my machine, now i have Visual Studio Pro
2005 which came with Sql Server 2005 Developer edition. I carefully
uninstalled anything I could find that was related to the express
edition before installing Developer. But still when I try to connect in
Management studio, it gives me only my Sql 2000 instance or a 2005
instance name SqlExpress. It fails trying to connect to the 2005
instance because apparently Express can't be connected to with this
tool.
Do I need to add a new instance? How do I get rid of the old one and
install a new one?
Any guidance appreciated, coming up with nothing in Books online and
this ng.
Bob(rvgrahamsevatenein@.sbcglobal.net) writes:
> I had installed Sql Express on my machine, now i have Visual Studio Pro
> 2005 which came with Sql Server 2005 Developer edition. I carefully
> uninstalled anything I could find that was related to the express
> edition before installing Developer. But still when I try to connect in
> Management studio, it gives me only my Sql 2000 instance or a 2005
> instance name SqlExpress. It fails trying to connect to the 2005
> instance because apparently Express can't be connected to with this
> tool.
> Do I need to add a new instance? How do I get rid of the old one and
> install a new one?
> Any guidance appreciated, coming up with nothing in Books online and
> this ng.
How did you run the install of Developer edition? Did you require a
named instance, or did you select a default instance? If you selected
the default instance, and you had SQL 2000 installed as a default instance,
then that install would have been upgraded to SQL 2005. Have you connected
to the instance check what @.@.version says?
Note that for an upgrage of SQL 2000 to succed you need at least SP3 of
SQL 2000.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi
Uninstall SQL Server Express Edition with all related installation (See in
ADD\REMOVE Program)
Moreover if you have a network (I have encountered some problems when it got
to set security File Stat )
, I'd suggest to unplug a cable and run SETUP
<rvgrahamsevatenein@.sbcglobal.net> wrote in message
news:1138996401.832192.216900@.z14g2000cwz.googlegroups.com...
>I had installed Sql Express on my machine, now i have Visual Studio Pro
> 2005 which came with Sql Server 2005 Developer edition. I carefully
> uninstalled anything I could find that was related to the express
> edition before installing Developer. But still when I try to connect in
> Management studio, it gives me only my Sql 2000 instance or a 2005
> instance name SqlExpress. It fails trying to connect to the 2005
> instance because apparently Express can't be connected to with this
> tool.
> Do I need to add a new instance? How do I get rid of the old one and
> install a new one?
> Any guidance appreciated, coming up with nothing in Books online and
> this ng.
> Bob
>|||Thank you for your replies,
I discovered when I did this same install on my home development
machine that what I had done wrong was to not specify for the Developer
Edition install to create a new named instance.
I was also unaware that VS2005 setup also installs SqlExpress, and that
it's apparently intentional that you end up with both running on your
machine. I'm assuming this is so you have Express available for testing
and deploying client apps containing stand-alone SqlExpress instances?
Bob Graham