Join Brien Posey for an in-depth discussion in this video Deploy SQL Server, part of Windows 10: Deploy and Manage Virtual Applications.
- [Instructor] Microsoft App-V has a dependency on SQL Server. So we're going to need to install a SQL Server that can store the App-V databases. Now I've gone ahead and copied the SQL Server setup files to this machine. This is our App-V server. So we can run SQL locally, or we can run it on a remote machine. But I'm going to do it locally because there was a bug that was introduced in App-V 5.0 Service Pack 3, and that bug persist in App-V 5.1, and the bug makes it difficult to connect to a remote SQL Server.
So we're going to install SQL locally. So here we have a SQL folder, this just contains the SQL server setup files. I'm going to run setup, and you'll note that we're installing SQL Server 2014. I'm running on Windows Server 2016, but SQL Server 2016 isn't supported for use with App-V. So that's why we're using the 2014 version. So I'm going to go to Installation, and I'm going to go with the New SQL Server stand alone installation, or add features to an existing installation option.
And this is going to launch SQL Server setup. So I'm running SQL Server 2014 Developer Edition. I'll click Next. I'm going to accept the license terms and click Next, and we don't have any errors here, so I'm going to click Next. And now we have to choose the setup role. We can choose SQL Server Feature Installation, SQL Server PowerPivot for SharePoint, or All Features With Default. I'm going to go with SQL Server Feature Installation and click Next.
Now we have to choose the features that we want to install. We need the database engine service, so I'm going to select that, and we also need the management tools. So I'm going to choose Management Tools - Complete, and that automatically selects Management Tools - Basic. I'll click Next, and now we're prompted to choose an Instance ID. I'm going to go with the default of MS SQL Server, and click Next. And I'm going to click Next here, and I'm going to use Windows Authentication, and I'm going to add the current user, and click Next.
And now SQL Server is ready to install. So I'm going to click on Install, and the installation process begins. Okay so it looks like SQL Server has been set up successfully. We can see that we've got green check marks all the way down, so I'm going to go ahead and close this out. Now our database engine is installed, but we need to create the actual databases that App-V is going to use. So what I'm going to do is go to my C Drive, and I'm going to go to App-V Setup. This is a folder that I use just to copy the App-V Setup files into.
So I'll go into the App-V Server 5.1 folder, and I'm going to run App-V Server Setup. Now there's one thing that's very important that you have to do here. We have to run this as an administrator or otherwise this process could fail. So I'm going to right click and choose Run as administrator. And that's going to launch App-V Setup. Now we're not actually installing App-V right now, we're only going to restage our databases. So I'm going to click on Install, and I'm going to accept the license agreement, and click Next, and you can see that we have a list of features to be installed.
So I'm going to pre-deploy the Management Server Database, and the Reporting Server Database. The Publishing Server doesn't need a database, so we don't have to worry about that. I'll click on Next, I'm going to go with the default location, and now we're prompted to specify the SQL Server instance that we're going to use. I'm going to use the default instance, and then we choose Management Server Database. I'm going to go with the default configuration, and click Next, and then we have to specify the Management Server Machine Account.
I'm going to use the local computer. Then we have to specify the administrator login. Now as you may recall from one of the earlier videos, we set up a couple of active directory groups. And we're going to use one of those groups right now. The group that I'm going to use is poseylab, which is the name of my domain, /APP-V, _Admins. So that's my App-V administrators group.
I'll click Next, and now we're taken to a screen for the Reporting Database. And once again I'm going to use the default instance, and I'm going to use the default configuration and click Next. I'm going to use the local computer, and I'm also going to set the administrator login to the same group that I used a moment ago. That was poseylab/APP-V_Admins. And I'll click Next, and we can see that the Management Database and the Reporting Database are about to be installed, so I'll click Install, and now our databases are being installed.
And the set up process has completed successfully. So now all of our databases are in place and we're ready to move forward with the installation of App-V Server.
This course also maps to the corresponding domain within the Microsoft exam 70-696, Administering System Center Configuration Manager and Intune, and will help you prepare for MCSE certification.
- Installing and deploying App-V
- Sequencing an application
- Editing or upgrading an application
- Configuring applications for deployment in App-V
- Deploying apps with Intune