joshwaagmeester
Posts: 6
Score: 0
Joined: 11/29/2007
Status: offline
|
I have a SCOM server, it is the root management with the ACS collector and SQL reporting services installed. I have a shared SQL 2005 SP2 environment that houses all of our databases for SCOM. (Operations, Data warehouse and ACS databases)
When I run reports for ACS I receive the error below. Other SCOM reports run just fine(these database are on the same server too), it is only ACS. Also I have searched several forums and have tired the following;
1. Verify there is not a firewall blocking connection
2. Verify on the SQL server it is allowing remote connections; enabled TCP/IP protocol and ensured the SQL Browser is running. (followed KB 914277)
3. Navigated to http://SERVERNAME/reports, went to “Audit Reports”, Modified the “DB Audit” settings. Changed from “windows Integrated” to “stored credentials”
4. Verify the credentials used in SQL reporting services has full windows administrative rights and data_reader permissions on the “OperationsManagerAC” database.
5. Tired Several modifications to the connection string. Currently my connection string look like. data source=aisqldbc301;initial catalog=OperationsManagerAC;Integrated Security=SSPI
Error I am receiving:
An error has occurred during reporting process. Cannot create a connection to data source 'datasource1'. An error has occurred while establishing a connection to the server. When connecting SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)
Any Suggestions?
|
Printable Version
SCOM ACS reporting error - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread