So I have found from the installer a few pieces of feedback:
- When installing and connecting to SQL with integrated authentication, it would be useful to ask for credentials. Otherwise, I have to install the software using the user with which I would like to connect to SQL. I didn’t see this in the installation requirements, but maybe I missed it.
- When the installation will connect to SQL remotely, with integrated Windows Authentication, the Octopus Deploy service user should also be set to that user. For me it was still Local Service, and I had to change it manually in the Services console.