Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SQL access errors that cannot be found....

SQL access errors that cannot be found....

SQL access errors that cannot be found....

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.  

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?

RE: SQL access errors that cannot be found....

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?


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close