SQL access errors that cannot be found....

[Texmansru47]

I resolved the one problem of the error with the Site component manager, it has stopped, but now I get the following error:

Milestone 069 12/28/2006 12:40:26 PM SMSSERVER
SMS_DISCOVERY_DATA_MANAGER 679 This component failed to retrieve the list of SMS sites from the site database.
Possible cause: SQL Server problem.

Solution:
1. Review the immediately preceding status messages from this component about SQL Server errors.
2. Verify that this computer can reach the SQL Server computer.
3. Verify that SQL Server services are running.
4. Verify that SMS can access the SMS site database.
5. Verify that the SMS site database, transaction log, and tempdb are not full.
6. Verify that there are at least 50 SQL Server user connections, plus 5 for each SMS Administrator console.
If the problem persists, check the SQL Server error logs.

I am checking these solutions, but so far I have no idea what is wrong... any suggestions?

 

[NoCalAdmin]

the only other thing I can see to verify is the credentials SMS is using when gathering the data. Is SQL using Windows authenitcation? Are theh SMS credentials in a security group that SQL will allow to attach?

Tom