SQL 2008 Maintenance Plan Execution Error

andy18    SQL-related     SQL 2008 Integration Services Maintenance Plan

I am trying to setup some backup maintenance job for all the databases in the MSSQL 2008 Web edition server today as I have done for previous MSSQL 2005 Workgroup Edition. The entire setup process are exactly we did in SQL 2005 by going through the Management > Maintenance Plan and dragging and dropping the task that you wish to perform.

Well, sometimes things does not goes as you expect . When I tried to execute the maintenance plan to verify the plan was setup and should run as it should be, SQL 2008 throws me an error with some Integration Services error. read more

Cannot create Windows Service for MySQL.Error:0

andy18    Windows-related     MySQL Error.0

I was installing MySQL on a Windows 2008 64bits machine today. The installation went smooth as usual, I got the MySQL configuration screen wizard at the end of the MySQL installation and went through filling in those service configuration details, MySQL root ..etc. However, at the end of the execution part where it writes the changes, it shows the following message during the attempt to start the MySQL services.

Cannot create Windows Service for MySQL.Error:0

It was my first time getting this message as I have been setting up MySQL for lots of Windows server without any issues on the past. Here’s what I did to get it resolve:

1. Start > All Programs >MySQL > MySQL Server 5.x > MySQL Server Instance Config Wizard.
2. Hit the Next and select the options “Remove Instance” and complete the process.
3. Fire up the MySQL Server Instance Config again, this time select the Configure Instance with Standard Configuration and go through the setup again. It should get your MySQL configured again.

The possible cause of the error is due to the MySQL Services has been installed and started on your server’s prior to the configuration by MySQL. Removing the installed instances and reset it up will help to resolve this.