Exception 'SqlException': A network-related or instance-specific error occurred while establishing a connection to SQL Server

Question

Am having these errors appearing since the database was full.After enabling auto grow.We SCOM 2007 R2 installed with SQL Server 2008 R2.These errors are still present.Searched the web and never found this specific error

Exception 'SqlException': A network-related or instance-specific error occurred while establishing a connection to SQL Server

These are the event IDs that appear in the log.DBA has checked connectivity to the server and can view an active connection by the SCOM Account

Event ID 31551

Failed to store data in the Data Warehouse. The operation will be retried.

Exception 'SqlException': A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow
remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

A subscriber data source in management group Australia Post has posted items to the workflow, but has not received a response in 122 minutes. Data will be queued to disk until a response has been received. This indicates a performance or functional problem
with the workflow.

Workflow Id : Microsoft.SystemCenter.DataWarehouse.CollectEventData

Instance :

Event ID 2115

Instance Id : {D89A46AC-7B20-0C41-B76B-51866300E414}

A Bind Data Source in Management Group Australia Post has posted items to the workflow, but has not received a response in 7140 seconds. This indicates a performance or functional problem with the workflow.

Nicholas Li - MSFT
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

I somehow think the management pack is not able to communicate with the SCOM database.

Failed to store data in the Data Warehouse.

Exception 'SqlException': A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured
to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Notice how it says it can't find the server or instance.My SCOM UI is up and running well.Only thing here is that the default port 1433 was changed to 4102.Not sure if there would be any impact for Management pack defined
objects.

I have checked the document and found the some ports are configurable. I think you can configure the port according to it; and also ensure the configurations
are correct.

Thanks.
Nicholas Li - MSFT
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Thanks.Nicholas Li - MSFT
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Data Warehouse event data writer process failed to perform maintenance operation. Data was written to the Data Warehouse staging area but processing failed on one of the subsequent operations.
Exception 'SqlNullValueException': Data is Null. This method or property cannot be called on Null values.

Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectEventData

Instance name: SCOMServer

Instance ID: {D89A46AC-7B20-0C41-B76B-51866300E414}

Management group:

The only Null value that i see in the StateStage table is ManagedEntityMonitorRowId which is NUll

With the 31553 error.after disabling the affected Rules.Clearing out the
State.StateStage table and enabling the affected rules.It appears that the workflow is now flowing through.this may have been the result of enabling the rules when the firewall was blocked.Setting this to resolved.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.