Getting Started with ASP.NET MVC - Part 5: How to do programming with razor syntax
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
ms sql server 97
ms sql 93
sql server 89
sql 88
database 75
#SQL Server 75
tsql 65
#sql 62
t-sql 59
sql server general 56

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
February 2012 5
April 2012 4

SQLIdeas

Central Management Servers register error - "Can not add a shared registered server with the same name as the Configuration server"

Dec 10 2011 12:00AM by Paresh Prajapati   

You may know how can we register SQL Server instances with Central Management Servers (CMS) and also how can we perform multi server query with all of instances of registered SQL Server instances.

There you can see i have registered one shared SQL Server 2011 instance under CMS and named it Denali. Under Shared instance i have registered SQL Server 2008 and same SQL Server instance of Denali which i already registered.

Here SQL server 2008 successfully registered but SQL Server 2011 has encountered error. But how i have registered it which i am going to explain here.


 This is because same SQL instance already registered as shared SQL server.

How can i register same SQL Server Denali or 2011 instance again?

I have changed the port and applied static port as following from SQL Server TCP/IP properties which we will available at SQL Server Configuration Monitor.


 Then please see the screen shot below as i have register SQL Server Denali instance with port.


 Now both SQL Server registered successfully.


 Did you received it and how did you resolved?

Tags: sql, sql server 2008, sql server, ms sql, ms sql server, sql server denali, sql server 2011, database, sql server general, enhancements, SQL new features, sql errors, SQL Server Problems,

Paresh Prajapati
7 · 24% · 5483
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect


Submit

Your Comment
Sign Up or Login to post a comment.
"Central Management Servers register error - "Can not add a shared registered server with the same name as the Configuration server"" rated 5 out of 5 by 1 readers
Central Management Servers register error - "Can not add a shared registered server with the same name as the Configuration server" , 5.0 out of 5 based on 1 ratings
    Copyright © Beyondrelational.com Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising