Configuration manager is not listing all the SQL Server instances

Question

Hello All:

I have SQL Server 2008 R2 (Express) & SQL Server 2012 installed in my system (Windows 8) and I am able to connect both using SSMS. But the configuration manage is listing only SQL Server 2008.

Any help is highly appreciable.

Answer 1

you are able to see all the SQL Server 2012 services in you SQL Server 2008 R2 Service manager?

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

@Babu:

You meant SQL Server 2008 R2 configuration manager? If so, it is not showing SQL server 2012 services. It is showing only 2008 instance.

Answer 3

Can you try to run as Administrator & also Some policies should be enable for the network account & on WMI ,I guess meanwhile can you try with RUN as administrator.

or try with the service account -Still the same issue, share the error.

Are you getting any error when you are clicking services?.

---

Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 4

Try SQL Server 2012 Configuration Manager. Do you see 2008?

Usually old version of any software does not "see" the next version. To do that in the past with SS you had to install some hotfix or the latest version of service pack on the old version.

What is 2008 @@version?

---

Kalman Toth SQL 2008 GRAND SLAM
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012

Answer 5

Hi Suman85,

Based on your description, it seems that SQL Server Configuration Manager 2008 R2 and SQL Server Configuration Manager 2012 have not be installed. I suggest running SQL Server installation media and add Management tools feature. For more detail information, please refer to the following link:

Add Features to an Instance of SQL Server 2012 (Setup):
http://msdn.microsoft.com/en-us/library/cc281940.aspx

Editions and Components of SQL Server 2012:
http://msdn.microsoft.com/en-us/library/ms144275.aspx

---

Allen Li
TechNet Community Support

Answer 6

Hi Allen,

I have SQL Server Configuration Manager 2008 R2  installed but not its 2012 counter part. To install the same I ran SQL Server 2012 set up file. But the wizard is showing "Management Tools (Complete)"  as are already installed and not allowing me to install again.

Answer 7

Are you logged on as the administrator on the machine? It is possible that the administrator account has access to the 2012 Configurations Manager.

---

If you're happy and you know it vote and mark.

Answer 8

Hi,

Please see the below it is helpful :

http://blogs.msdn.com/b/dohollan/archive/2012/04/20/sql-server-2012-management-studio-darker-shades-of-blue-theme.aspx

---

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

Answer 9

Hi, based on your reply, I suggesting checking the following things:

1. Search “SQL Server Configuration Manager” again within the programs to check whether SQL Server Configuration Manager 2012 has been installed.
2. Run SQL Server installation file again, when SQL Server Installation Center opens, click “Options” to make sure this is a SQL Server 2012 installation file.

---

Allen Li
TechNet Community Support