SQL express studio

I have installed SQL express 2008 with SP3 on 2008R2. I want to install the management studio express but when I download and run the management studio express I receive an error from program compatibility assistant stating I must apply sql server 2008 service pack 1 or later. I checked in the logs and sql express reports its already on SP3.
Any ideas how I resolve this?
LVL 6
Sid_FAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ess KayEntrapenuerCommented:
uninstall, download correct mgt studio
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ess KayEntrapenuerCommented:
0
Sid_FAuthor Commented:
I seem to have the correct management studio "SQLmanagementstudio_x64_enu.exe"
 OS details in original post. I am running 2008 express not 2012
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Sid_FAuthor Commented:
I have run this file from a different MS link and although I can run it without errors. I can't see any where to install the studio even under tools. I seem to have all the same options for the management studio exe as I have for the original sql express exe.
0
Ess KayEntrapenuerCommented:
Try this.



Go here

www.update.microsoft.com

Run the update check.
See if there are any more updates for:
 SQL Server
Windows
SQL Management



If not, go to Add Remove programs. uninstall SQL management


Go here
https://www.microsoft.com/en-us/download/details.aspx?id=30438

Make sure all requirements are met, then install and try again
0
Sagir87Commented:
Hi guys,

When it prompts for compatibilty issues you can run the program and install the SQL Management Studio and later apply the latest service pack.
0
Sid_FAuthor Commented:
Removed all, searched again reinstalled again and it worked.  I didn't install any extra updates. It seems there are a few versions of sql express and sql express studio available but not all work together..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.