I was told in the Windows Server 2008 R2 Hyper-V forum they no longer wished to attempt to assist me with my issue.
http://social.technet.microsoft.com/Forums/en-US/windowsserver2008r2virtualization/thread/8be91c1f-e293-45bf-9734-5d9fc1d60f3f/ And so was referred here.
I have attempted to clone a SQL Server 2008 R2 virtual machine in Hyper V. The cloning worked and the VM started just fine. However, the SQL Server will not start. I ran Sysprep on the machine with the shutdown action.
Then in Hyper V performed an export of the VM to an alternate HD location. Followed this with an import in Hyper V. Gave the system a different name during the initial system startup. The new VM booted fine and everything on it worked except SQL Server.
The server was joined to a domain and I have reentered credentials for the domain account used as a service account for all SQL Services.
The error in the System event log is Event 7000, "The SQL Server (MSSQLSERVER) service failed to start due to the following error: The system cannot find the path specified."
I have verified that all the SQL folder/file structure is in place and at the same location/drives present in the server template VM. I attempted to drop the SQL server name using SQLCMD and the sp_dropserver stored procedure (the intent to then use sp_addserver
%computername% in order to add it back withe new computer name) but was told SQLCMD was not a supported command.
Also attempted, as suggested in the Windows forum, to perform the following:
ECHO DECLARE @SRVNAME SYSNAME >%SQL%
ECHO SELECT @SRVNAME = @@SERVERNAME >>%SQL%
ECHO EXEC SP_DROPSERVER @SRVNAME >>%SQL%
ECHO EXEC SP_ADDSERVER '%COMPUTERNAME%' >>%SQL%
OSQL -E -n -w 20 -s -h-1 -i "%SQL%"
::DEL /F "%SQL%"
But, this also had no effect as the MSSQLSERVER service could not be started (I assume).
I attempted to run a repair on the installation, and this produced multiple errors regarding lack of all the system databases and multiple files. All of which (including the system DBs) I verified were actually present.
I am used to using VMWare to make this a practically seemless process using VM Templates (Have created multiple fully functional SQL Server 2008 templates and clones in VMWare), but Hyper V has no such basic capabilities. But, it is what have to work
with at this time.
So...how do I get this process to work in Hyper V?Read more...