DIFFERENCE BETWEEN CENTRAL MANAGEMENT SERVERS AND LOCAL SERVER GROUP

If you have used either of them, they look somewhat like this

So what is the difference?

In the case of LSG, the servers are visible only to the user who created them. This is because, the settings are configured as a xml file which is located in the following (the location may vary somewhat across environments)

C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\120\Tools\Shell\RegSvr.xml

On the other hand CMS configurations are stored in the msdb database and hence are visible to all users provided they have the requisite priveleges.

So when to use what?

Use LSG when you need to create shortcuts to servers/instances for yourself instead of cluttering the CMS view which might not be relevant to others.

On the other hand, lets say you are part of a team that works with pretty much a fixed set of servers, then use CMS as the'll be accessible to all.

Now why are the above tow used ? Well, it's for the following:

  • Policy implementation across multiple instances. This eliminates the need to do them on individial instances one at a time.
  • Code implementation across multiple instances. This is pretty much an extension of the above point.
  • Connection shortcut. Simply double/right click and you are in the instance. This is because the passwords are stored beforehand during creation.

7 comments:

Mehak Shaikh said...

dvxc

Christopher said...

SEO from true internet sites which get natural and organic guests and have in no way expired or been via insanereview re-designs is the easiest way to convey to Search engines find your website bears some authority which it will click the search jobs

Cynthia Boyd said...

user experience design firms
This post is really valuable that designed for the new visitors. Pleasing work, keep on writing.

Nicholas Olson said...

I certainly appreciate your stuff provided in the blogs.
more tips here

Gynecomastia Surgeon said...

The stuff in the blogs blows out my mind.
UX companies

Robet John said...

Hmm!! This blog is really cool, I’m so lucky that I have reached here and got this awesome information.
mobile design company

wafaulatowski said...

No Deposit Slots 2020 | Do You Need A Deposit Bonus?
The Casino Welcome Bonus: For new players, the bonus is no longer 안성 출장샵 needed. Casino 대구광역 출장샵 Welcome 안양 출장안마 Bonus 2020 — 제주도 출장샵 How do we get 목포 출장샵 a no deposit bonus? It's not just a bonus that's