jana
asked on
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).
Also, we ran the version script for your refrence, the result is:
How can we installed the SQL Server Configuration Manager in our S!L2008 express or is there another way to enable remote network connections?
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)
How can we installed the SQL Server Configuration Manager in our S!L2008 express or is there another way to enable remote network connections?
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.
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.
ASKER
'Management Tools - Basic' cam't be checked, it's grey-out (uncheckable).
Here is the link for MS Express:
https://www.microsoft.com/en-ca/download/details.aspx?id=30438
Is this you used?
https://www.microsoft.com/en-ca/download/details.aspx?id=30438
Is this you used?
ASKER
Yes. The problem is that when run, the option is not available, grey-out.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Server Configuration Manager is part of the database engine. You can't install it alone.
ASKER
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.
Yes, Vitor, that is what we understand that the manager is installed along with the engine.
Ok, will try the sp3.
ASKER
For some reason after installing service pack 3, it permitted to install SQL Server Configuration Manager.
ASKER
Thanx
ASKER