Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
ms sql server 119
ms sql 118
sql server 116
sql 115
database 102
tsql 81
#SQL Server 78
t-sql 75
#sql 71
sql server general 67

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
June 2013 5
April 2013 5

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
6 · 22% · 7054
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 © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]