how to remove sql server 2008 r2 express

Question

how to remove sql server 2008 r2 express

Marsha

Ten Centuries

Points: 1015
More actions
March 5, 2014 at 9:22 am

#284300

I have a server originally setup with SQL Server 2008 Standard edition. All servers are currently running SQL Server 2008.
Software was installed which installed SQL Server 2008 R2 express edition on this server.
Now I can not maintain my maintenance plans using SQL SERVER 2008 Management Studios.
I understand the concept to common components and that R2 version is higher and the common components
now run as R2.
What I have read, to get rid of the R2 Express Edition, I have to remove both versions of SQL Server and then reinstall
SQL Server 2008 Standard edition.
Is this my only solution, has anyone else been able to get rid of the Express version without uninstall both versions.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

is this your production server?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Marsha Ten Centuries Points: 1015 More actions · Answer 2

Marsha

Ten Centuries

Points: 1015

March 6, 2014 at 11:39 am

#1694835

No it is not.

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

Have you installed 2008 R2 with new instance or done the upgrade the existing 2008 to 2008 R2?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

paul.knibbs SSCoach Points: 15320 More actions · Answer 4

Are you sure the 2008 Management Studio isn't still on there? I have 2008 R2 and 2012 installed on this machine, and the Management Studios for both are still available.

Marsha Ten Centuries Points: 1015 More actions · Answer 5

R2 was installed to a new instance.

I have given up looking for another solution.

the only soluction I have is to uninstall both instances, and then reload sql server 2008

thank you for you time.

Marsha

Marsha Ten Centuries Points: 1015 More actions · Answer 6

Yes, 2008 Management Studios is the only version on the machine.

It gets back to common components. the Highest version controls the common components.

R2 is the higher release. Therefore it has modified some of the components used by Management Studio.

So now, maintenance plans can not be modified from this server for the 2008 version.

I can go to another sql server 2008 instance and modify the maintenance plans.

I am going to uninstall bother versions and then recreate the SQL Server 2008 setup.

I am lucky because this server has not been used to much.

I can see this happening again whenever third party software is loaded to a server

and no one looks to see what it needs database wise.

free_mascot One Orange Chip Points: 27169 More actions · Answer 7

Hello Marsha,

Thanks for sharing your experience it might help someone.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

dan-572483 SSCoach Points: 15870 More actions · Answer 8

Is it not possible to upgrade or make a new installation of SQL Management Studio verision 2008 R2? That would seem to be a much better solution than uninstalling & reinstalling the whole thing.

Marsha Ten Centuries Points: 1015 More actions · Answer 9

I am trying not to introduce a new version of SQL Server at this time.

I want ot keep to 2 versions.

If I add SQL Server 2008 R2 out there, then someone will try to use in

and I will have a third version to worry about.

It is hard to get everyone off the old versions.

Marsha

dan-572483 SSCoach Points: 15870 More actions · Answer 10

I am not suggesting installing a new instance of SQL Server. I suggested installing the 2008 R2 version of SSMS (or Management Tools). Then you should fully compatable with both 2008 and 2008 R2.