sysprep 후 필요한것
-- sysprep 하기전
-- linked server 가 있는 경우
-- windows 의 sid 가 변경된 경우 master key 를 백업 후 복원
BACKUP SERVICE MASTER KEY TO FILE = 'C:\service_master.key' ENCRYPTION BY PASSWORD = 'P@ssw0rd'
-- sysprep 후
-- 복원
RESTORE SERVICE MASTER KEY FROM FILE = 'C:\service_master.key' DECRYPTION BY PASSWORD = 'P@ssw0rd' FORCE
services.msc 에서 sql insname 확인
-- mssql$insname -> mssqlserver
-- default
net stop mssqlserver
net start mssqlserver
-- instance
net stop mssql$insname
net start mssql$insname /m /f /T3608
-- default
sqlcmd -S. -A
-- instance
sqlcmd -S.\insname -A
create login newhostname\Administrator from windows with default_database=master
go
alter server role sysadmin add member newhostname\Administrator
go
grant connect sql to newhostname\Administrator
go
alter login newhostname\Administrator enable
go
select srvname from master.dbo.sysservers where srvid = 0
go
-- default
exec sp_dropserver 'oldinstancename'
go
exec sp_addserver 'newinstancename', local
go
-- instance
exec sp_dropserver 'oldhostname\oldinstancename'
go
exec sp_addserver 'newhostname\newinstancename', local
go