Windows Server 2003 box ( not known to me until now )

In SSMS Express Edition , I run

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')

yields

9.00.1399.06 RTM Express Edition


However , in Add/Remove Programs it says "Microsoft SQL Server 2005
(64-bit)"


My question is : do I have Express Edition of the server installed ? Or
some other version ?

I am thinking that SSMS Express Edition got installed with VS , or a
separate tools install ... anyway what's important is the server version I'm
on ...

Go to Control Panel\Add-Remove Programs and then click "Microsoft SQL Server
2005" on the list and then click Uninstall button. A Windows shows up and
lists the installed SQL Server 2005 instances and shared components below.

You can also see the installed SQL Server 2005 instances via SQL Server
Configuration Manager (Start\Programs\Microsoft SQL Server 2005\Configuration
Tools) and Services MMC (click Start\Run-> services.mmc)

--
Ekrem Onsoy - SQL Server MVP


"John A Grandy" wrote:

I'm finding that you can remove everything in Add/Remove Programs that says
"MS Sql Server ..." , but then when I install Sql Server 2005 Developer
Edition , it shows that an Express instance remains on the server.

How do I remove this Express instance once and for all ?

Thanks.



"Ekrem Önsoy" <Ekremnsoy (AT) discussions (DOT) microsoft.com> wrote

Do you see that Express Edition instance on the list of Add/Remove Programs?
If so, did you try to select that instance and remove it only? If you only
choose the express edition instance name from the installed instances list
and leave the shared components as they are, then you'll be able to remove
it for good if things go smooth during uninstallation.

Where does it say that? On the Instance Name window where you choose an
installed instance to upgrade from the Installed instances list?

If you can't see the Express Edition instance on the list of Add/Remove
Programs at all, so did you try to uninstall it manually?
http://support.microsoft.com/default...b/909967/en-us

--
Ekrem Önsoy - SQL Server MVP



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

In Add/Remove Programs , there was only one instance listed, "Microsoft SQL
Server 2005 (64-bit)". That's the one I removed.

Yes , it's when install is asking me which instance I wish to
install/upgrade that it displays the SQLEXPRESS instance in the list ( the
only entry ). When I re-installed , I ( obviously ) didn't select it. I
selected "Default Instance".

Here is a clue : I've located the Express files and they are in the \Program
Files (x86)\ dir. So ( although this is a 64-bit machine ) , someone
installed the 32-bit version of Express.

Manual uninstall looks darnright scary.



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

btw, I should mention that the reason I want to get rid of the Express
instance is that I've been experiencing weird security errors with our app
on this box that's I haven't seen before in any other environment.

But is it even possible for an x86 Express instance to interfere in any way
with the functioning of a x64 Developer instance ?


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

John A Grandy (johnagrandy-at-gmail-dot-com) writes:
Not what I can think of. But is this the same box, where you not able
to install the tools? Now here is a point of interference: you cannot
have both SSMS Express and real SSMS on the same machine, and I would
guess the reasons you don't see the tools is that SSMS Express is hiding
somewhere.

Since you don't see the Express instance in Add/Remove programs, your
machine appears to be a bit shaky anyway.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Yes , same box.

But Express SSMS was listed in Add/Remove Programs and I uninstalled it
before installing Sql Server 2005 Developer Edition ( I forget the exact
name it was listed as, but it definitely indicated I was uninstalling
Express SSMS , or the entire toolset ).

What I don't understand is why a total install of all components , features
, etc. doesn't work. Usually this does the trick for Microsoft installers.



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

As far as I know there's no x64 version of SQL Server 2005 Express Edition,
so it's expected that it would be x86...

I can't really reckon what you are talking about here.

As Erland has already mentioned, the only think that comes to my mind is
SSMSE and SSMS collision.

Probably you installed SSMSE as a stand-alone setup so the only tool was
itself on the Add\Remove Programs list and it uninstalls only itself.

Sometimes it happens somehow... This evening I was at a new customer for
some problems with his ASP.Net application and he was claiming that the
problem was about SQL Server... I checked the error messages and the problem
was actually about his codes. While I was checking his server, I also
encountered that his installation was corrupt in terms of setup. I was not
seeing the instance name in the list of Add\Remove Programs (only Microsoft
SQL Server 2005 but there's no any installed instance on the list even
though there was one which was up and running). I don't really know how he
did that, but it unfortunately happens...

--
Ekrem Önsoy - SQL Server MVP



"John A Grandy" <johnagrandy-at-gmail-dot-com>, iletisinde þunu yazdý,
news:uwEITVkCKHA.3368 (AT) TK2MSFTNGP02 (DOT) phx.gbl...