Hey all,
Our platform engineering team has issued a policy requiring (for automation and maintenance purposes), they do not want to have any services running directly on the SQL nodes. Is it possible to have a server that is not the database server be the SQL processing server?
The fact that it uses a connection string to connect the database implies that this should be possible. I just don't see any documentation that talks about installing the service on a server other than the SQL server. Plenty of scenarios I see around job servers and even containerization, just nothing about whether it is possible to assign the SQL processing service on a secondary host.
I only ask because I have attempted to manually install the One Identity software on a separate server from the database resides and I just could not get it to work.
Thanks!