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

Group Policy Event ID 1058 Error Code 1326 (The user name or password is incorrect)

Suspicious event log Event ID: 4905

DCOM received error "2147746132" from...