No mapping between account names and security ids was done

I just created a new SQL Server 2008 server with Hyper-V and was in the process of setting up my VMs complete with AD.   When I got to the point of adding a SQL Server 2008 to the mix I recieved the above error when I was trying to add the domain users as the service owners.   Another odd thing was when I tried to add a domain account to a local security group it would say the user was added however I would not see the account show up in the group.


After rebuilding my AD and SQL 2008 VMs a few times I realized that when I ran SYSPREP on my baseline image I did not check the box called “Generalize” which removes all unique information like the SID.   Hence, it appeared that I was running 2 machines with the same SID.   After rebuilding my baseline image and running SYSPREP the correct way everything worked correctly.


 

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>