MICROSOFT DYNAMICS NAV (SQL ERROR)

Hello, today i will share something slightly away from Microsoft Dynamics NAV but it's very important. We all know Dynamics NAV can not be accessed when SQL server is not running. I woke up to this error "Cannot connect to WMI Provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class[0x80041010]." upon running SQL configuration manager.
It is very frustrating to start with system errors even before you begin development.
If you get the same error just do what am about to describe.

Solution

• Open command line as administrator
• Navigate to C:\Program Files (x86)\Microsoft SQL Server\Number\Shared\
• Run command "mofcomp sqlmgmproviderxpsp2up.mof"
• You will receive the following message when your command is successful.

The value of Number depends on the version of SQL Server:nnn

Microsoft SQL Server 2012	110
Microsoft SQL Server 2008 R2	100
Microsoft SQL Server 2008	100
Microsoft SQL Server 2005	90

 For details click here