• State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 2373 views
  • Users 0 members are here
Options
Related
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?

pacman_d
over 5 years ago

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!

Parents
  • 0 over 5 years ago

    is right. This is a common configuration. The thing is, and that might be disturbing, that you need one service that services the Master SQL Server (up to 7.1.x) / Update Server (since 8.0) queue. That queue is by default named after the database server the database is running on. This is just the default configuration that eases the setup. You can change all that according to your requirements.

Reply
  • 0 over 5 years ago

    is right. This is a common configuration. The thing is, and that might be disturbing, that you need one service that services the Master SQL Server (up to 7.1.x) / Update Server (since 8.0) queue. That queue is by default named after the database server the database is running on. This is just the default configuration that eases the setup. You can change all that according to your requirements.

Children
No Data