This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Is it possible to completely abstract all of the server functions/roles to reside outside of the SQL server?

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!