- Microsoft Application Virtualization Cookbook
- James Preston
- 439字
- 2021-07-16 20:43:39
Configuring SQL Server
Microsoft SQL Server is required to host the App-V Management and Reporting databases. With the exception of very large deployments of App-V, SQL server can be collocated on the App-V Management Server (and on the Publishing server as well).
Getting ready
This recipe assumes that you have provisioned and domain-joined a server with the name APPV1, and that you have a valid licence to install Microsoft SQL Server 2008, 2008 R2, or 2012 at the Standard, Enterprise, Datacenter, or Developer Edition levels. Note that the Express edition is not supported.
How to do it...
Here are the fundamental steps involved in this recipe:
- Install and configure a default setup of SQL Server.
- Launch the SQL Setup application, select Installation and New SQL Server stand-alone installation or add features to an existing installation.
- Allow the Setup Support Rules check to complete and click on OK.
- Enter your product key and click on Next.
- Review the terms of the licensing agreement, tick the I accept the license terms box, and click on Next.
- Allow the Setup Support Rules check to finish. At this stage, you might have a warning on Windows Firewall stating that certain ports are not open. This can be safely ignored as we are hosting the App-V Management server and SQL server on the same machine. Click on Next.
- On the Setup Role screen, select SQL Server Feature Installation and click on Next.
- On the Feature Selection screen, tick the Database Engine Services option and click on Next.
- Allow the Installation Rules check to complete and click on Next.
- Leave the Default instance option selected with Instance ID set to MSSQLSERVER. Click on Next.
- Review the Disk Space Requirements check and click on Next.
- Accept the defaults for the Service Accounts option and click on Next.
- On the Database Engine Configuration set, select Windows authentication mode and click on Add Current User to make the account that you are logged in with an administrator on SQL Server. You must use the same account to install the App-V Management Server in the next recipe.
- On the Error Reporting page, accept the defaults and click on Next.
- Review the Installation Configuration Rules check and click on Next.
- Review the final SQL Server configuration and click on Install to begin the setup.
- After the installation is complete (depending on your hardware this could take a few minutes), click on Close to finish the setup process.
推薦閱讀
- 造個小程序：與微信一起干件正經事兒
- Instant Apache Stanbol
- Android 9 Development Cookbook（Third Edition）
- HTML5游戲開發案例教程
- 教孩子學編程：C++入門圖解
- Learning Network Forensics
- Python面向對象編程：構建游戲和GUI
- Learning Python Design Patterns
- 領域驅動設計：軟件核心復雜性應對之道（修訂版）
- Kivy Cookbook
- 從Excel到Python數據分析：Pandas、xlwings、openpyxl、Matplotlib的交互與應用
- 網絡數據采集技術：Java網絡爬蟲實戰
- jQuery從入門到精通（微課精編版）
- Spring Data JPA從入門到精通
- Microsoft HoloLens By Example