share same SQL for SCCM and SCOM


hi all,

i planning deploy sccm , scom in infrastructure. planning share same sql server both sccm , scom. read in blogs , if share same sql instance sccm , scom, reporting service of 1 product destroy install of another. kindly advice me how proceed in scenario. should install multiple instances of reporting service on same server? if so, should buy more sql licenses (installing multiple sql instance on same server). kindly give me valuable advices.

regards.

hi,

opsmgr takes on security of reporting services makes instance of reporting services unusable other applications. can install new instance of reporting services on same server or host new instance of reporting services on different server. if hosting reporting point on different site server, follow install reporting services , rs site role on same system. ssrs capable of using remote sql server database.

it specified in doc best practice not share sql

https://technet.microsoft.com/en-us/library/bb694127.aspx?f=255&mspperror=-2147217396

meanwhile, think you could post in sccm forums or scom forums:

https://social.technet.microsoft.com/forums/windowsserver/en-us/home?category=configurationmanager

regards.


please remember mark replies answers if , unmark them if provide no help. if have feedback technet support, contact tnmff@microsoft.com



Windows Server  >  Migration



Comments

Popular posts from this blog

DCOM received error "2147746132" from...

DFSR RPC replication errors 5014 1726 with large files over VPN

ADFS 3.0 Event ID 4625 | An Error occurred During Logon | Status: 0xC000035B