When sqlserver is installed in the domain environment, the question "No ing between account name and security identity" occurs.

To install the lync demo environment, I have installed three virtual machines, DC, front-end, and backend.

When installing sqlserver on the backend, I try to use the same account settings for all services. Whenever I select the "atosdemo \ sqlservice" account created on the DC, the account displayed in the account text box always becomes"S-1-5-21-2000478354-688789844-839522115 \ sqlserviceIt should have been a long string of characters in the domain name. And prompt"There is no ing between account names and Security Identifiers ".

 

Based on experience, the preceding long string should be the SID of windows. This reminds me of the fact that the SID between windows is repeated.

My three VMS are cloned through a Windows master disk.

So I executed the sysprep command on the front-end and back-end virtual machines and re-installed sqlserver to solve the problem. Facts have proved that my judgment is correct.

:), The lesson is: Remember sysprep when playing multiple virtual machines...