Which two actions should you perform to complete the server configuration?

A network administrator creates a virtual machine from a template that has SQL Server installed.

You need to ensure that you can create SQL Server databases on the new virtual machine.

Which two actions should you perform to complete the server configuration? Each correct answer presents part of the solution.
A . Execute the SP_ADDSERVER statement.
B . Edit the Instance Names registry key.
C . Execute the SP_SERVER_DIAGNOSTICS statement.
D . Execute the SP_DROPSERVER statement.
E . Run setup.exe and specify the upgrade option.

View Answer

Answer: A,D

Explanation:

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

References: https://serverfault.com/questions/377377/creating-a-sql-template-for-vmware