We've primarily been running SCOM for auditing purposes and today I attempted to run some performance reports. When I run the report it comes back with this error:
Cannot create a connection to data source 'DataWarehousePerf'. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this feature may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Names Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The SQL db is on a separate box and it does have named pipes enabled. The DW write action acct is not locked out and is able to connect via SQL Management Studio and see tables, etc.
Any suggestions on what is causing this and how to troubleshoot it?