How to install SQL Server Configuration Manager for Microsoft SQL 2008 Express

We have SQL2008 installed in a Windows 8 and when we went to find SQL Server Configuration Manager to enable remote network connections, we couldn't find.  Assuming that maybe when the SQL Express was installed, that option wasn't chosen, we ran the setup again and found it wasn't there either and the option there are gray-out (see pix below).

sqlresult
Also, we ran the version script for your refrence, the result is:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4042.0 (X64)   Mar 26 2015 21:18:04   Copyright (c) Microsoft Corporation  Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 

Open in new window


How can we installed the SQL Server Configuration Manager in our S!L2008 express or is there another way to enable remote network connections?
rayluvsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

rayluvsAuthor Commented:
Found the SQL Studio for Express and ran it to install the tool and no luck (see pix below)

sql2008-studio-tools
ZberteocCommented:
You have to check the Management Tools - Basic in order to get the Management Stdio for Express.

I don't think you need to use any configuration manager for remote connection. Just make sure that the firewall is open for port 1433 on both in and out.
rayluvsAuthor Commented:
'Management Tools - Basic' cam't be checked, it's grey-out (uncheckable).
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

ZberteocCommented:
Here is the link for MS Express:

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

Is this you used?
rayluvsAuthor Commented:
Yes.  The problem is that when run, the option is not available, grey-out.
David Johnson, CD, MVPOwnerCommented:
you must upgrade to service pack 3 minimum for SQL 2008 before you run it.

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
Vitor MontalvãoMSSQL Senior EngineerCommented:
SQL Server Configuration Manager is part of the database engine. You can't install it alone.
rayluvsAuthor Commented:
We have sp2 installed and the DB works fine, but will proceed  to install sp3

Yes, Vitor, that is what we understand that the manager is installed along with the engine.

Ok, will try the sp3.
rayluvsAuthor Commented:
For some reason after installing service pack 3, it permitted to install SQL Server Configuration Manager.
rayluvsAuthor Commented:
Thanx
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.