New, clean install. DBA used default instance. During my first Management Server install I included mssql as the instance name in the setup wizard for OpsDB and DW. This resulted in my Management Servers not being monitored due to being unable to connect to the DB. I found the resolution here:
I altered configservice.config to drop the instance, after which all servers turned monitored and healthy. I figured I would have an issue somewhere with my DW as well although cannot find a config file pointing to the instance?
I am having event ID errors on my Primary Management Server 10801 Discovery Data couldn’t be inserted into the database. DataAccessLayer Warning Event ID 33333 and opsmgr sdk service error 26319, an exception was thrown while processing getdatawarehousestoredprocedureresult
Looks to me like I have a DataWarehouse issue?!? DBA does not want to setup a new SQL server for me.
I researched moving the Datawarehouse in attempt to find connection keys. What I have found points to the reg key, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Setup\DataWarehouseDBServerName
Under which both values for databaseservername, and datawarehousedbservername currently have the instance name included. Should I try to delete the instance names?
Is their a way to re provision the primary mgt servers connection to the dw?