I'm new to setting up Domains so I might be missing something simple here...
I've installed SQL Server 2008 on a Windows Server 2008 R2 box and I have another WS2008 R2 box acting as the domain controller.
I've joined the SQL server to the domain and it seems to be behaving itself fine. I can ping the DC by name and IP address.
I created a domain user 'SPSQLAdmin' that I want to use for database access with SharePoint but I can't seem to log on to SQL with this user.
SQL complains, saying that the user belongs to an untrusted domain.
I've configured the DC to delegate control for any service to the SQL Server but it doesn't improve the situation.
What should I try next?
Thanks in advance.