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.
Best Answer
When you say you "reinstalled the domain controller" you mean you created a new domain in a new forest? or you added a new DC to the existing domain?
My guess here is that you have the sql server in a domain that no longer exists. You will need to remove the server from the previous domain & join it to the new one, before you can access any of the domain objects for sql server permissions.