VMware converter error SQL_CANTOPEN during conversion

Posted on 2011-09-09
Last Modified: 2012-05-12

After yersterdays success converting one old Win2k Professional machine to a VMware Workstation VM using Standalone Converter 4.0.1, I am now trying to do my remaining machine, which I naively thought would be easy.

Following bestway's general advice I have turned off the AV software and used msconfig to disable as many non-essential services as I dare.

There are no databases or other server processes running on the box, mostly just files and a few old apps we need to keep alive.

When I did the conversion the first time it stopped at about 85% and popped up a dialog box saying that I needed to increase the size of the registry database. I could also see the task had failed with the error

FAILED: A general system error occurred: SQL_CANTOPEN: unable to open database file

(Note: I have no SQL databases on either the source PC or the PC on which the VM is being generated)

I have now rerun the process and it now gets to 98% (during "Applying reconfigurations") but it still comes up with this error.

Anyone got any ideas what might be causing this? If anyone can suggest the easiest way to upload all the diagnostics logs I'll do it, but I just tried and it complained about one of the files in the zip having a gz extension...
Question by:rjebb
  • 2
  • 2
LVL 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
Are you applying any configuration changes in the job, e.g. decreasing or increasing size of partitions etc

this usually happens at the end of the job (98%).

Are the disks full on the Source?

Author Comment

Comment Utility
Not intentionally. I have checked the "apply reconfigurations" option in the final step of the converter wizard simply because it said if I don't the new VM may not start, but the only change I've made is to ask it to increase the memory size. I've left the disks alone.

The disks are quite full though,

C: has 605MB of 7.98GB free
D: has 327MB of 10.6GB free
LVL 117

Accepted Solution

Andrew Hancock (VMware vExpert / EE MVE) earned 250 total points
Comment Utility
try a straight P2V with no changes, just accept the defaults
LVL 22

Expert Comment

by:Luciano Patrão
Comment Utility

That's a very generic error. Most of the times just start again and then will work.

But go with the hanccocka solution above. Do not change anything and try again.

Also try to use IPs not dns names.


Author Closing Comment

Comment Utility
OK, that did it

I first deleted a bunch of crud off the D drive that I had planned to clear out after the P2V, then uninstalled various applications that won't be needed off the C drive.

This gave me about 1.5GB free on both drives

Then I did a P2V just accepting the defaults all the way through and the conversion has completed successfully. I'm just installing VMware tools in the VM now so I can get the graphics sorted out.

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now