SQL Services Not showing

  • Hi, I'm a newbie to SQL Sever 2008 R2, I'm having an issue with sql services not running, its first says "requesting data from WMI provider " then it returns the following error "the remote procedure call failed".

    Please help.

  • Very little to go on there. Usually these things are due to security settings. Does the account that you set SQL Server up to run under have the appropriate access? You should validate that, and that the services are running under the right account by looking at the Configuration Manager. Also, check the SQL Server error logs. Even if it's not starting completely, the start up process will output some information. You can also check the windows error logs for the same thing.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • i think i was a little bit vague in explaining. my problem, its actually in the sql server configuration manager where im getting this error "the remote procedure call failed[0x800706be]". as a result it shows no sql services running under the "sql services " tab.

    Please help.

  • OK. Have you checked the error logs, both SQL Server and Windows? I can't really suggest a whole lot more than that without more details than that you have an error message. It could be that the install went wrong, but I still lean towards security. That's a pretty common issue. But we need more data.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply