When installing App Volumes using a external MS SQL Server you are faced with the question of what authentication method to use, Integrated or SQL Server.
Integrated is always preferred however there’s a catch, the installer says it’ll
use the server’s SYSTEM account, so that means something like
In SQL Server you can’t make a login for a Computer Object, so you have to:
- Create a Security Group
- Add the server(s) to the Security Group
- Create a Login for the Security Group and assign it permission on the database