Hi ,
我们并不推荐在虚拟机安装了数据库的情况下,通过sysprep修改SID。原因是修改SID的过程中,会导致计算机名的改变,而由于计算机名的改变,数据库会停止工作。 可以参考以下的文章:
Running SysPrep on a Virtual Machine with SQL Server Installed https://blogs.msdn.microsoft.com/virtual_pc_guy/2006/11/13/running-sysprep-on-a-virtual-machine-with-sql-server-installed/ Will SQL Server work after changing the Machine's SID https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cf026542-8b09-4dfa-8538-0f0b9e4b3196/will-sql-server-work-after-changing-the-machines-sid?forum=sqlsetupandupgrade 如果回复对您有帮助的话,请您把回复标记为答复,感谢您的理解和支持。 此致 Candy
Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.