SQL Server 2014 Management tools

Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training costs, and poor DBA productivity. To keep up with these demands of complex enterprise database management solutions, SQL Server 2014 includes updated management tools to make it easier for administrators to create, manage, and maintain SQL Server solutions.

Click here to read full article on SSWUG.org

Advertisements

Six top SQL Server 2012 management tools you should know about

Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training costs and poor database administrator (DBA) productivity.

To keep up with these new demands of complex enterprise database management solutions, Microsoft ships SQL Server software with a broad group of several graphical management tools that help DBAs and developers efficiently create, manage and maintain SQL Server solutions, and allow them to quickly resolve complex performance and configuration problems.

Checkout my article here, in which I gave an overview of the key features of these graphical SQL Server 2012 management tools.

This article is published on SearchSQLServer.techtarget.com.

SQL Server Configuration Manager : Cannot connect to WMI provider – Invalid class [0x80041010]

Following error dialog pops up today, when I tried connecting to SQL Server Configuration Manager on my SQL Server 2008 production server:

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]

This error appears to happen when .mof files (Managed Object Format (MOF)) don’t get installed and registered correctly during set-up. To resolve this issue, I executed the following mofcomp command in command prompt to re-register the *.mof files:

mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

Note: mofcomp.exe is responsible for registering and storing the data associated with .mof files

This error disappeared after the MOF file has been successfully parsed and I can now access SQL Server Configuration Manager without any problem ;0).