Will a SQL Server client alias survive a sysprep?

Posted by shufler on Server Fault See other posts from Server Fault or by shufler
Published on 2012-03-29T17:17:29Z Indexed on 2012/03/29 17:32 UTC
Read the original article Hit count: 234

Filed under:
|
|

I want to sysprep a Windows Server 2008 R2 SP1 machine that has SQL Server 2008 R2 SP1 installed (for reference, SQL Server 2008 R2 has a new sysprep feature that allows the instance to be sysprepped).

On the server is a SQL Server client alias that points to the default SQL Server database engine instance. For reference, the alias is called Alias-SQLServer and has been configured in both 32-bit and 64-bit cliconfig versions (that is, both registry keys exist)

The alias points to the local instance as the image will be used to create development VMs and the installation script for the application that is being developed will use the SQL Server client alias in order to generalize the installation scripts.

I can't seem to find information about whether the sysprep tool will update the SQL Server client alias's registry keys with the server's new name once it's unsealed. My guess is that it is not; how is sysprep to know that the server name the alias points to will be different for each image? Right?

Perhaps if the alias points to localhost instead of the server name this will work?

© Server Fault or respective owner

Related posts about sql-server-2008-r2

Related posts about alias