ERROR !! SQL Server Configuration Manager Cannot Connect to WMI Provider

Problem:

Error Message – “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 the SQL Server Configuration Manager. Invalid namespace[0x80041010]” when trying to launch SQL Server Configuration Manager.

 

1

 

Cause:

This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server. The 32-bit instance and the 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.

 

Solution:

To work around this problem, open a command prompt, type the following command, and then press ENTER:

Command:

mofcomp “%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof”

Note: For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

2

3

 

 

Hope this was helpful !!!!

How to backup Table in SQL

Taking backup of SQL Server table is possible in SQL Server. Below are some options to backup a table in SQL Server.

1. Generate Table Script with data
2. Make a copy of table using SELECT INTO
3. Export Data using SSIS to any destination

 

Method 1 : Generate Table Script with data

1 2 3 4 5 6

 

 

Method 2: Make a copy of table using SELECT INTO

Script:

 

7

SELECT * INTO DataBase.dbo.BackUpTable FROM SourceDataBase.dbo.SourceTable

 

Method 3: Export Data using SSIS to any destination [IMPORT / EXPORT Wizard]

The SQL Server Import and Export Wizard can copy data to and from any data source for which a managed .NET Framework data provider or a native OLE DB provider is available. The list of available providers includes the following data sources:

  • SQL Server
  • Flat files
  • Microsoft Office Access®
  • Microsoft Office Excel®