I am trying to add a new login in SQL Server 2005. I can go into the security properties for the database in SQL Management Studio, and I can select a domain user, but when I click OK to close out of the security properties page SQL tells me it can't find the domain user I'm trying to add. It does let me add the domain administrator account as a SQL login, but that's the only one that works. Any ideas on how I can solve this issue?
This is on a virtual machine hosted on server 2008. I recently reinstalled my domain controller (which isn't a production dc, it's just for testing purposes) and this vm was created in the previous domain. Not sure if that has anything to do with this or not, but it's suspicious.