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
Post a Comment