AD mapping error with VMware

sendalot

I'm trying to setup a VMware Data Center with Win Server 2008 R2 and SQL 2012.
I have a VM that hosts DHCP and DNS services and created an account called "SQLAdmin" that is a local admin to a SQL VM as well.


However, when I try to install SQL 2012 on the SQL VM, I get error “S-1-5-XX-XXXXX-XXXXX-XXXXX-1104: No mapping between account names and security IDs was done.”


I couldn't find a way to get around so I used default settings. then later on, I cannot access the database on Management Studio.


I so far have refreshed ipconfig and turned off all Windows Firewall(s). I erased the AD account to start from scratch as well with no luck.


Any help would be appreciated, thanks.

BGraves

Difficult to troubleshoot this kind of issue with limited information. Have you been able to google the error and setup and see if similar issues are solved out there? That might give you a lead. Also, obviously check and make sure that the all of the users you are trying to add are valid users....

sendalot

I am able to log on to the SQL VM with the AD account. I already ran a search and for most people, turning off firewalls and restarting worked. Argh!

BGraves

How did you create your SQL VM, sysprepped Windows image?
Error: No mapping between account names and security IDs was done - SQLServerCentral
Seems a lot of people are posting this error when using that type of image. Sorry, difficult to say exactly what it is.

sendalot

That article indirectly led to discovering the cause of the problem.

now all is well.

Thank you very much.

BGraves

Glad you were able to get it resolved, as SQL is about my least favorite thing in the world I feel your pain.