[Script of Oct 24th] Enroll SQL Server instances on multi server into an existing SQL Server Utility

Script Download: EnrollInstances.zip https://gallery.technet.microsoft.com/scriptcenter/Enroll-SQL-Server-66687842

This PowerShell sample script is used to enroll SQL Server instances on multi server into an existing SQL Server Utility. This script applies to SQL Server 2008 R2 and SQL Server 2012 editions.

SQL Server Utility can manage the SQL Server environment as a whole through the concept of application and multiserver management in it, so after created one utility control point, administrator need to enroll instances of SQL Server into the SQL Server Utility. If your task included in below two scenarios, this script will be one good assistant.

  1. There are multiple managed instances need to be enrolled tothe SQL Server Utility.
  2. We can store the server and instance names in one .txt file.

 

image image
image image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery