You may know how can we register SQL Server instances with Central Management Servers (CMS) and also how can we perform multi server query will 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 get it earlier? How did you resolved?
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 get it earlier? How did you resolved?
0 comments:
Post a Comment