- 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 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 Testing with CasperJS
- Visual Basic 6.0程序設計計算機組裝與維修
- Rust實戰
- Mastering Concurrency in Go
- 機器人Python青少年編程開發實例
- Mastering KnockoutJS
- Advanced Oracle PL/SQL Developer's Guide（Second Edition）
- Learning ArcGIS for Desktop
- AIRIOT物聯網平臺開發框架應用與實戰
- 匯編語言編程基礎：基于LoongArch
- MySQL入門很輕松（微課超值版）
- 大數據時代的企業升級之道（全3冊）
- Python第三方庫開發應用實戰
- 數據結構：Python語言描述
- 金融商業數據分析：基于Python和SAS