Author: Chathura Ariyadasa

♚Father ♚Innovative Technical Architect ♚ Cyber Security Strategist ♞ vCISO | vCIO ♞ Blogger & an Adrenaline junkie...

SQL configuration manager remote procedure call failed (0x800706be)

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.

<nnn> Version
140 SQL Server 2017
130 SQL Server 2016
120 SQL Server 2014
110 SQL Server 2012
100 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

c:\program files (x86)\Microsoft SQL server\140\shared>mofcomp.exe sqlmgmproviderxpsp2up.mof

3) Re-register the SQL Server provider DLL

regsvr32 “C:\program files (x86)\Microsoft SQL server\140\shared\sqlmgmprovider.dll”

Issue 2 Solution:​

 

Continue reading “SQL configuration manager remote procedure call failed (0x800706be)”

Correctly Install Applications on a Remote Desktop Server

When installing an application on a Terminal Server, because multiple people will be using the application at once, there is actually a special method that you should use to install the applications. Here’s two methods to do it the right way.

The GUI Method [Starting from Server 2012]

To get started open control panel. Switch to the small icon view, and look for Install Application on Remote Desktop Server, double-click on it. Now you can simply go through the next, next, finish style wizard which will help you get the application installed.

The Command Line Method [Server 2008 & The Best Practice]

You will need to change your user mode to installation mode by using the Change User /Install comand.

you could go ahead and safely install the application, but once the application is installed don’t forget to change back to execution mode, you can do so by running the Change User /Execute command.