Hi All,

I have configured the central management server for all data collector tasks. MDW resides in the central management server. But I am having issues to upload the data to central management server from remove collector. I have configured the SQL proxy and also granted required permissions to the user id. Any suggestion will be appreciated!

Error Message

Executed as user: NT_xxx\xxxx. Failed to connect to the management data warehouse server Inner Error ------------------>  Row #:    0 Source: "Microsoft SQL Server Native Client 11.0" Description: "Login timeout expired" Help File: "(null)" Help Context:    0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.  Row #:    1 Source: "Microsoft SQL Server Native Client 11.0" Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online." Help File: "(null)" Help Context:    0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.  Row#:    2 Source: "Microsoft SQL Server Native Client 11.0" Instance: "" Procedure: "" Line#:    0 Error Number:     53 Error State:   1 Error Severity:  16 Error Message: "Named Pipes Provider: Could not open a connection to SQL Server [53]. " Help File: "(null)", Help context:    0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.  OLE DB Error Record dump end.  Process Exit Code 1.  The step f

I have enabled the firewall for default port 1433 which resolved this issue.