I never expected it took me whole afternoon on just installing a App-V, well, I do admit I did went out for other stuff, but it is little ridiculous how complicated and lack of correct information the whole process is.
I write this post to help myself and others for future reference. If you do run into similar issue, hope this post can help.
Test Environment:
Windows 2012 runs HYPER-V on it
SQL 2008 R2 runs on Hyper-V
SQL Preparation:
This is the part which kills everyone. If you think you just jump on the SQL and create couple of DB and jump back and run installation wizard, then I can tell you will see following errors.
This warning is telling you that you didn’t prepare DB as what Microsoft wanted and go back now!
Funny thing is it only has one button “OK”, no cancel?
If you continue to install, you will run into The error was : Invalid object name ‘dbo.RoleAssignments’ after you finish installation.
The correct installation method is following kirxblog and prepare the DB.
Essentially, there are two methods to prepare DB. You can either bring installation disk on SQL server and run through installation wizard which requires you to install whole bunch of craps or you can manually install it as what this post will tell you.
1. get DB scripts ready
In terms of extract DB script, you need to find installation exe file and run it with /layout as parameter.
Once you have done that, you will following structure
2. Create 3 AD groups
Now, according to installation instruct of script, you need two groups which are read and write. I also create 3rd group called AppVAdmin for managing.
You need to add App-V server computer account into AppvAdmin group. Also domain admins as well.
3. Modify DB scripts with Powershell script
The original DB script which you extracted from installation exe file requires SID of AD groups in terms of making it work! It’s not easy to find those SID and not mention other nasty stuff.
Thank for Kirx beautiful powershell script, we are able to prepare those DB scripts with Powershell script.
Instead of all other nasty information, all what you need to do is to provide name of groups and name of DBs. Powershell script will prepare the DB script and help you to finish the work.
download Kirx script and edit.
Found those lines and replace it
If you never run powershell script on this serve, you may want to unlock it.
Make backup for your DB scripts and copy them to c:\temp folder like this.
c:\temp\ManagementDatabase and also report database script.
Copy kirx script to c:\temp
Run it, if it works, it should return with no result.
However, it will change the file name under those DB scripts.
Original folder.
Changed
3. run the Scripts on DB
Copy your new script to SQL server and open management studio
Run 1-1 Database script which will create new DB on SQL
Run all other script base on DB you just created
4. Add AppvAdmin group to db.Ower on new DB
Your AppvAdmin group should contain App-V server account by now
Install Prerequisites for App-V
You need to download Microsoft C++ 2010 x86 version and install on App-V server. Yes, it is x86 not x64 version!
Otherwise, you will get this one.
Install App-V
Now, we can start to see those fish eggs , oh, no, orange Apps in the Box
Now, Unless you have SQL on your App-V box, otherwise, DO NOT tick those boxes. It will change your wizard steps.
Once you finish installation, I strongly recommend you to restart your App-V and most likely, you just add computer account into AppvAdmin group and requires restart to take effect.
Otherwise, you may see this.
After restart App-V, you should be able to this no error on console.
Reference:
http://kirxblog.wordpress.com/2012/11/01/remote-database-preparation-for-app-v-5/



Note


















