cownax.blogg.se

Ms sql management studio 2008 r2 set local server
Ms sql management studio 2008 r2 set local server








ms sql management studio 2008 r2 set local server

In that above screenshot, I connected to a CMS on P-SQL20081\CMS, and that instance stores the list of SQL Servers. From there, it’s basically the same as your local registered server list – only it’s centralized: Registered Servers window showing a CMS Right-click on Central Management Servers and you get options to set one up.

ms sql management studio 2008 r2 set local server

To configure it, open SSMS 2008 and go into the Registered Servers window. How to Set Up a Central Management Server When the DBA opens SQL Server Management Studio, they point at the CMS, and SSMS grabs the list of registered servers from there. With a CMS, the list of registered servers is stored on the central SQL Server. In a shop with two DBAs, they both have their own desktops (plus maybe laptops) and each machine has its own list of registered servers. Sounds simple – and it is – but it comes in handy, and it’s practically a requirement for a good policy-based management deployment. At my last company, we had a hard enough time telling everybody when we’d finished adding a new server, or what the new server’s name was, or when we didn’t need to look at a server anymore.Ī SQL Server CMS is just a central repository that holds a list of managed servers. This is useful for fast-changing shops where there’s a lot of servers added and removed.

ms sql management studio 2008 r2 set local server

Got more than one DBA? Want to make your life easier? You might want to configure a Central Management Server.










Ms sql management studio 2008 r2 set local server