March 5, 2014 at 9:22 am
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.
March 6, 2014 at 4:49 am
is this your production server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 6, 2014 at 11:39 am
No it is not.
March 6, 2014 at 11:27 pm
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."
March 7, 2014 at 3:18 am
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.
March 7, 2014 at 8:12 am
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
March 7, 2014 at 8:20 am
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.
March 10, 2014 at 3:21 am
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."
March 11, 2014 at 11:07 am
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.
March 13, 2014 at 11:46 am
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
March 13, 2014 at 11:50 am
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.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply