Microsoft Windows Server 2003

Microsoft SQL Server 2005 Developer Edition

This is the DVD ( .iso ) package downloaded from MSDN Subscriptions.

I rebooted , and ran \SQL Server x64\Servers\setup.exe and chose to
install everything.

I then rebooted and I ran SP3.

I rebooted and looked at my Start menu but SSMS was not available.

So , I then ran \SQL Server x64\Tools\setup.exe

and selected "install to local hard drive" for everything , but the
installer then said install could not proceed because there was nothing to
install because everything selected had already been installed.

I have searched my entire hd for sqlwb.exe ( this is the executable for
SSMS , correct ? ) and it is not there.

Does anyone know how to force (re)installation of the tools , irrelevant of
the existing state ?


"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Going through setup meticulously , I found a screen I hadn't seen before :

"Name: Microsoft SQL Server 2005 Tools Express Edition
Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more
information about edition upgrades, see the Version and Edition Upgrades
topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online."



So, apparently the installer thinks that the Express Tools are installed --
even though they are not : there are some components of Express installed at
\Program Files (x86)\ but the tools are not present.

Is there some way to fake-out the installer so that it doesn't think that
the Express Tools are installed ?



"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

This guy had the same problem , and he said he was able to run
SqlRun_Tools.msi directly to force install the tools ...

http://aspadvice.com/blogs/ssmith/ar...-the-suck.aspx

The installer stinks. Is the Sql08 installer better ?


"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

I think you should stop and take a breath =) I know from your previous post
that you are some kinda confused about this stuff.

If SSMS would be installed with your installation, it would be some here
like: "C:\Program Files (x86)\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe ". Check it out again if
it's there or not. Also, under normal circumstances you'd see the shortcut
of SSMS on Start\Programs\Microsoft SQL Server 2005 menu. If you don't find
these files, then probably you did not select Client Tools during
installation. Because it's not selected by default and you should be
selecting it from the Featured to Install window by click on the Advanced
button and selecting Client Tools (I'm telling this from my memory but it
should be correct).

However, in your situation you have already applied SP3 so you'll be getting
a warning about it. So you should use SKUUPGRADE parameter. Here, I'm giving
you a link where you'll find info to install only Client Tools from Command
Prompt. Check out the "To install SQL Server 2005 Client Tools only" topic:
http://msdn.microsoft.com/en-us/libr...9(SQL.90).aspx Also, remember
to take a look at the SKUUPGRADE parameter. Otherwise it'll block the
installation, and I should warn you that this parameter causes installed SPs
to disappear so you'll need to apply the SPs again after installing Client
Tools.

Why are you trying to install the Express Edition again? Are you trying to
upgrade your installed Developer Edition to Express Edition? It's not a
supported upgrade path and it made me confused indeed. You probably
installed the Developer Edition as a Default Instance and then you started
an Express Edition setup and you chose to install it as a Default Instance
again so it tried an upgrade attempt with failure which is expected.

I think you have not see SQL Server 2000' s Setup and this makes a lucky
person =) and I think SQL Server 2005's Setup is quite good when compared to
its predecessor. The problem looks like you are not familiar with this
product.

--
Ekrem Önsoy - SQL Server MVP



"John A Grandy" <johnagrandy-at-gmail-dot-com>, iletisinde þunu yazdý,
news:el%23RhnkCKHA.4792 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

I have no interest in installing anything related to Express. In fact , the
first thing I did on this box was attempt to deinstall everything realted to
Express going to Add/Remove Programs and removing everything with "Microsoft
SQL Server" in the title.

Even though these steps successfully removed the Express tools ( but not the
Express instance ), it did not remove some information somewhere that
indicates that tools are already installed.

The problem I was having was using the Developer install package to install
Developer Edition tools , but it thinking that they were already installed.

However, running SqlRun_Tools.msi directly overcame this problem.

I think the root of the problem is that VS05 installer installed Express and
did not do a good job providing a good method to deinstall everything via
Add/Remove Programs.

My current problem is how to delete the Express instance.


"Ekrem Önsoy" <iletisim@ekrem[REMOVETHIS]onsoy.net> wrote

Actually, you don't have to install an Express Edition with VS... You can
deselect it from the Features to Install (or similar) window to avoid an
Express Edition instance installation.

If you can't see SQL Server Express Edition instance from the Add\Remove
Programs list, then you should try to remove it manually according to the
link I gave you before.

--
Ekrem Önsoy - SQL Server MVP
http://www.ekremonsoy.net - http://ekremonsoy.blogspot.com
MCDBA, MCITPBA & DBD, MCSD.Net


"John A Grandy" <johnagrandy-at-gmail-dot-com>, iletisinde þunu yazdý,
news:e%23R0iEyCKHA.5956 (AT) TK2MSFTNGP03 (DOT) phx.gbl...

Heh heh ... reading comprehension is really sufferring on this thread.

As I've explained before quite clearly, I inherited this box and it already
had a lot of stuff installed. My goal was to remove everything related to
Express. I did so by removing **everything** in Add/Remove Programs with
"Microsoft SQL Server" in the title. This removed Express tools , but not
the Express instance.

Next , I installed SQL Server Developer edition -- however the install
package would not allow me to install the tools because it thought that they
were already installed.

At this juncture, I only have Developer components listed in Add/Remove
Programs.

However, I still have an Express instance in \Program Files (x86)\ -- and
that is what I wish to remove.


"Ekrem Önsoy" <iletisim@ekrem[REMOVETHIS]onsoy.net> wrote

Are you sure SQL Server Express is still installed?

1) do you see a service for it listed in the Services applet?

2) the presence of the program files folder does not mean Express is
installed. The uninstaller leaves that folder intact because you might have
user databases there.

If you are sure the program is actually still installed (even if it is not
listed under Add/Remove Programs; is the presence of the program files
folder really your only evidence?), did you try the Windows Installer
Clean-up Utility or MSIZAP?

Linchi talks about MSIZAP here:

http://sqlblog.com/blogs/linchi_shea...-is-your-frien
d.aspx

And the WICU is linked to here:

http://sqlblog.com/blogs/aaron_bertr...-xp-sp3-msxml6
-sp2-sql-server-debacle.aspx






On 7/24/09 2:16 PM, in article OAGporIDKHA.3740 (AT) TK2MSFTNGP04 (DOT) phx.gbl, "John
A Grandy" <johnagrandy-at-gmail-dot-com> wrote:

Yes, unfortunately Services applet lists "SQL Server (SQLExpress)" as an
installed service.


"Aaron Bertrand [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote