Sql – Creating a SQL Template for VMware

sqltemplatevmware-esxi

Are there tools and/or scipts available to create a 'Golden' VMware SQL template? We are gearing up to create a number of SQL servers running in our virtual farm and have yet to figure out how to strip the server name hooks out of the SQL/Server install.

Best Answer

All you should need to do is run sp_dropserver then sp_addserver to change the server name after the template is renamed. The restart the SQL instance.

exec sp_dropserver 'OldserverName'
go
exec sp_addserver 'NewServerName', 'LOCAL'
go

An easier option would be to install SQL after the fact using a script within sysprep to automatically log into the server after it's been syspreped then install SQL automatically via a batch file.