There are some situations When you open SQL server configuration manager you get an error saying “Remote procedure call failed (0x800706be)”
There may be 2 possible root causes to trigger this error;
Issue 1. Shared Files for All Instances of SQL Server
Issue 2. Not pointing the correct Configuration Manager Path in an Multi DB instance enviornment
Below, will try to address all those two possible issues
Issue 1 Solution:
Common files used by all instances on a single computer are installed in the folder <drive>:\Program Files\Microsoft SQL Server\nnn\. <drive> is the drive letter where components are installed. The default is usually drive C. <nnn> identifies the version. The following table identifies versions for the paths.
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008
We will do step by step:
1. Checking the WMI Repository
If using Window Server 2008 and above, run command from command prompt to verify WMI repository: winmgmt /verifyrepository
If you get any error, please contact your OS team for WMI rebuild.
2) Recompile the MOF file
cd C:\program files (x86)\Microsoft SQL server\140\shared
Step 1: Open the SQL server configuration manager location through Windows Start->type SQL server configuration manager ->right click->Open file location
you may notice that the shortcut is pointing to SQLServerManager10.msc or any other
Spep 2: go to the path what the msc is located
Step 3: you will see their is a higher version of the same is present in my case SQLServerManager11.msc, so I changed the shortcut path to the latest version i.e. I changed target of the SQL configuration manager shortcut to as below;
Step 4:After saving the above change, open the SQL Server Configuration manager from the windows start menu. and now you should see all the SQL server Services in it.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
The cookie is used by cdn services like CloudFare to identify individual clients behind a shared IP address and apply security settings on a per-client basis. It does not correspond to any user ID in the web application and does not store any personally identifiable information.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
1 year 24 days
Used by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
This cookie is set by doubleclick.net. The purpose of the cookie is to determine if the user's browser supports cookies.
5 months 27 days
This cookie is set by Youtube. Used to track the information of the embedded YouTube videos on a website.