System center configuration manager and SQL server



  • For those who use SCCM, do you host the database on the same server as the SCCM application, or do you have SQL server as its own VM?

    I am replacing SCCM in our test environment, and will be doing the same eventually in our production environment. The current one has SQL server host locally. But since were looking to start over, I figured it would be worth weighing the pros and cons of keeping SQL Server local or having you be on the remote server.



  • @eddiejennings said in System center configuration manager and SQL server:

    For those who use SCCM, do you host the database on the same server as the SCCM application, or do you have SQL server as its own VM?

    I am replacing SCCM in our test environment, and will be doing the same eventually in our production environment. The current one has SQL server host locally. But since were looking to start over, I figured it would be worth weighing the pros and cons of keeping SQL Server local or having you be on the remote server.

    In my last job, we ran SCCM for a while and we had everything on one VM. (Small set up with ~200 PCs). It ran OK.

    I'd suggest keeping it to one host for your test environment, and separating them out for your production setup.