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?
The steps described in the following link worked for me when faced with a similar scenario –
Basically just go with procedure of moving DW Warehouse and just browse through all the locations there (Reg, files and DB itself).
If it is the default instance then you do not need to specify the instance name.
There are more details here – https://docs.microsoft.com/en-us/system-center/scom/manage-sqlserver-communication?view=sc-om-1801#update-reporting-server
As Rem says; it is basically the same as moving the DW.