Demo Enrolling a Managed Instance using SQL Server 演示注册管理实例使用SQL Server.docxVIP

Demo Script Enrolling a Managed Instance Demo version: 1.0.0 Last updated:  DATE \@ M/d/yyyy 5/28/2010  Contents TOC \h \z \t Heading 3,2,pp Topic,1,PP Procedure start,3   HYPERLINK \l _Toc260837981 Overview  PAGEREF _Toc260837981 \h 3  HYPERLINK \l _Toc260837982 Key Messages  PAGEREF _Toc260837982 \h 3  HYPERLINK \l _Toc260837983 Key Technologies  PAGEREF _Toc260837983 \h 3  HYPERLINK \l _Toc260837984 Time Estimates  PAGEREF _Toc260837984 \h 3  HYPERLINK \l _Toc260837985 Setup and Configuration  PAGEREF _Toc260837985 \h 3  HYPERLINK \l _Toc260837986 Task 1 – Running the Configuration Wizard  PAGEREF _Toc260837986 \h 4  HYPERLINK \l _Toc260837987 Opening Statement  PAGEREF _Toc260837987 \h 6  HYPERLINK \l _Toc260837988 Step-by-Step Walkthrough  PAGEREF _Toc260837988 \h 7  HYPERLINK \l _Toc260837989 Segment #1 – Enrolling a Managed Instance using SQL Server Management Studio  PAGEREF _Toc260837989 \h 8  HYPERLINK \l _Toc260837990 Segment #2 – Automating Instance Enrolment using PowerShell  PAGEREF _Toc260837990 \h 20  HYPERLINK \l _Toc260837991 Summary  PAGEREF _Toc260837991 \h 25   Overview This document provides a written script for showing how to enroll a managed instance with a Utility Control Point. This document can also serve as a tutorial or walkthrough of the technologies being exposed. Key Messages SQL Server Utility Control Point allows you to enroll a managed SQL Server instance using SQL Server Management Studio SQL Server Utility Control Point allows you to automate the instance enrolment using PowerShell Key Technologies This demo uses the following technologies: Microsoft SQL Server 2008 R2 Microsoft Visual Studio 2010 Time Estimates Estimated time to complete the demo: 15 min Setup and Configuration System Requirements Microsoft SQL Server 2008 R2 Default Database Engine instance PowerPivot Database Engine instance Microsoft SQL Server Management Studio Microsoft SQL Server Bu