While installing SQL Server 2008 on a Hyper-V VM you may encounter following problem: setting accounts for SQL Server services you’ll get an error box with message
"No mapping between account names and security IDs was done"
The account data: domain, login, password are correct, but the message comes over and over again and doesn’t let continue the setup.
In this situation there’s a good time to check if the VM to install SQL Server is using a copied VHD. Once the VHD is just copied (for example, you are installing a domain, setup a blank VHD and copy it to deploy different domain member machines) you have to change the machine ID for each (!) VM to deploy.
To change the ID before installing SQL Server 2008 in the VM with copied VHD use the built-in Windows tool SysPrep.
Using SysPrep on the VM do not forget to check the box “Generalize”. You will need to enter keyboard, location and probably some additional settings on the next VM start.
Enjoy!
PS: BTW, the best way is still to setup the machine fro SQL Server from scratch, I guess.
UPD: Good article here: http://macraem.wordpress.com/2010/02/25/no-mapping-between-account-names-and-security-ids-sql-server-install-and-sysprep-generalize/
No comments:
Post a Comment