This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

How to monitor SCCM 2007 R3 SP2: See this SQL connection error below

Question
0

Sign in to vote
Hello, we have a reoccuring problem in our SCCM environment, we have constant problems connecting to our SQL clustering nodes and the SCCM console can't connect, plus numerous errors in the SMSDBMOM.log, I want to monitor this and I can't find anything related in the SCCM MP. Is there anything I can do with SCOM to monitor this behavior:

CSSQLPolling Thread::Unit - unable to get SQL connection

***[08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

***[011000][67][Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen (Connect)

***Failed to connect to the SQL server.

Thanks Julio.
- Edited by JulioLiz Friday, March 23, 2012 7:27 PM
Friday, March 23, 2012 4:07 PM

Answers

0

Sign in to vote
Hi,

Would you please let us know how if you want to monitor the contents in the log file? If so, please refer to the following method:

How to Create a Log File Simple Event Detection Unit Monitor in Operations Manager 2007
http://technet.microsoft.com/en-us/library/bb381375.aspx

Using a Generic Text Log rule to monitor an ASCII text file – even when the file is a UNC path
http://blogs.technet.com/b/kevinholman/archive/2009/06/20/using-a-generic-text-log-rule-to-monitor-an-ascii-text-file-even-when-the-file-is-a-unc-path.aspx

Hope this helps.

Thanks.

Nicholas Li

TechNet Community Support
- Marked as answer by Nicholas Li Monday, April 2, 2012 2:16 AM
Tuesday, March 27, 2012 10:08 AM