Divine Flame (5/18/2012)

---

seb 30496 (5/18/2012)

---

Hi

I'm trying to set up Windows-based SQL logins on an existing SQL 2008 installation. The installation was created by cloning a previous virtual machine, and where and how that was set up, only God knows...

The New Login screen can't seem to see the list of domain users. I browse to the domain, it can see that; it can see a Users node under that. But the node is empty. If I change the "Location" to the Users node under the domain, and type in the name of a (known, existing) domain user in the "Enter the object name", and then press "Check name", it gives an error.

The same thing happens when I go to Services and try to change the SQL Server service startup account to a domain account (not that I actually want to do this, just to test whether anything on the machine can browse domain users).

I don't know much about networks, and the person who does is being... let's say, not helpful. Anyone have any idea why this is happening?

have you tried creating the login using query instead os SSMS? You can try it like this:

CREATE LOGIN [DomainName\UserName] FROM WINDOWS

In the above query change the DomainName to your domain name & UserName to your domain user name. If you get any error, post them here.