SQL Server Windows Management Instrumentation failed // IT Management Solutions

SQL Server Windows Management Instrumentation failed

The MySQL team has been continuously improving its products on the Windows platform. Along this line, we’ve responded to a request from our users of Workbench on Windows – to provide remote access to Windows Servers using Windows management methods – as an alternative to SSH.

Managing a MySQL server obviously requires access to the target machine, which usually requires elevated rights for certain tasks like restarting the server or manipulating the configuration file on Windows (where this file is in a protected path). For local connections this is mostly not a big deal. However for remote boxes security measures prevent easy manipulation of such essential things like server processes. In this blog post we discuss native Windows management and how it can be used in MySQL Workbench.

MySQL Workbench first introduced remote access via SSH (secure shell), a widely used and well known approach for secure remote access, especially in the Linux world. Microsoft Windows does not come with an in-built SSH server, hence an additional installation is due. For Windows users is SSH quite an unkown land and very often security rules, policies, company restrictions etc. do not allow to add extra software or open access via SSH. Also setting up SSH is non trivial and can be quite a challenge forless technical users. For these reason we have added support for native Windows management, which comes at no extra cost, since it is built into Windows already.

The management we will discuss here is not about how to add users or databases to a MySQL server and things like that. It’s rather about administering the MySQL server Instance that we’ll discuss here – for instance, DBA tasks such as manipulating the MySQL configuration file or controlling the server processes. Windows comes with a universal management layer called WMI (Windows Management Instrumentation). WMI is a very powerful means to query all kind of data from a Windows system (drivers, BIOS, motherboard, performance data etc.) and to manipulate the state of certain components (services, subsystems etc.). If you are going to manage a MySQL installation on a Windows server from a Windows machine (Workbench supports Windows 7) then WMI is the way to go. Due to security restrictions (e.g. UAC) WMI access works best in a domain setup as it already has all the necessary pieces to make the interplay work seamlessly. At the end of the article I have included additional information to help when setting up native Windows management for non-domain environments. However beware as that involves disabling some important UACs, which is not advisable in most instances.

See also:
  • dji phantom 3 pro

You might also like

XP Pro

by emancipatedmind

Benefits to XP Pro:
Better support for digital cameras & scanners.
Faster boot.
Better memory management.
Greater support for legacy applications.
Built-in remote access (RDP) and remote assistance.
Windows File Protection - alerts you when a system file is overwritten with an unknown version.
System Restore - automatically roll back to a previous system configuration.
Wider compatibility with games and game controllers.
Microsoft will support XP for over a year after support for 2000 is terminated.
More system configuration tools such as MSCONFIG.

Microsoft Software Windows Small Business Server Premium 2008 English 5 Client- 2 DVD
Software (Microsoft Software)
  • Includes everything from Standard Edition plus a second server with Windows Server 2008 Standard, and Microsoft SQL Server 2008 Standard for Small Business
  • Designed and priced especially for small businesses, Windows Small Business Server 2008 is an all-in-one server solution designed to help you keep your data more...
  • Windows Small Business Server 2008 helps protect your vital business information from loss, by backing up the data on your network and helping enable you to recover...
  • Gives you highly secure access to business contacts, calendars, e-mail, files, and other important desktop resources from any Internet-connected computer, so you...
  • Includes Small Business Server 2008 Premium Edition and 5-pack of Small Business Server 2008 CAL Suite for Premium Users or Devices (User or Device, chosen after...

Look beyond APM to unified performance monitoring  — TechTarget
ORLANDO, Fla. -- The lack of interoperability among traditional performance monitoring tools means data centers must use -- and pay for -- multiple tools. But movement toward unified performance monitoring could change all that.

Symantec Symantec pcAnywhere 11.0 Host Only
Software (Symantec)
  • Industry-leading remote control, combined with remote management and file transfer capabilities, helps quickly resolve helpdesk and server support issues
  • Use new Remote Management tools to quickly solve specific problems without the need for a full remote control session
  • New! pcAnywhere Command Queue can be used to send files, folders, and DOS commands to one or more computers
  • Symantec Packager provides the ability to create customized installation sets by choosing components to install, default settings, default host and remote objects...
  • New! Symantec Packager can deploy multiple applications to Windows® NT/2, Windows Server 2003, and XP machines for simultaneous deployment and installation
TP-Link TP-LINK TL-PS110P Single parallel port fast ethernet Print Server, E-mail Alert, Internet Printing Protocol (IPP) SMB
CE (TP-Link)
  • LED Indicator: Status, 10Mbps, 100Mbps
  • Power Consumption: 3.3V DC, 2A
  • Protocols: TCP/IP,(Remote Virtual USB),LPR/LPD
  • Management : Web Management, Telnet Configuration, HP Web Jet Admin
  • Interface: Parallel Port Fast Ethernet RJ-45 Port
  • Compact and smart design, can be located almost anywhere
  • Compatible with up to 230 printer models on the market
  • Supports multi-protocol and multi-OS, easy to set up in almost all network environments
Hummingbird Communications Exceed Multiplatform Multilanguage 7.1.1
Software (Hummingbird Communications)
  • Software Type: Connectivity • Emulation • Remote Access/Ctrl • Remote Management • System Management
  • Software Category: Network Management Tools
  • Operating System: Microsoft Windows 2 Server, Microsoft Windows 95, Microsoft Windows NT Server, Microsoft Windows NT Workstation, Microsoft Windows XP Home Edition...
Canon USA (Lasers) Canon imageCLASS D1320 Monochrome Printer with Scanner and Copier
CE (Canon USA (Lasers))
  • Copy and print at the same speed up to 35ppm
  • Duplex versatility - 2-sided copying, scanning, and printing
  • 500-sheet front loading cassette plus 50-sheet multipurpose tray; additional 500 sheet cassette available
  • Legal size platen glass and 50-sheet multipurpose tray handle variety sizes of paper stock
  • User-friendly 5-line LCD for easy navigation

Related Posts



Copyright © . All Rights Reserved