Cannot authenticate a domain user with SQL Server 2008
Posted
by
Sambo
on Server Fault
See other posts from Server Fault
or by Sambo
Published on 2010-10-30T00:38:06Z
Indexed on
2011/01/10
17:55 UTC
Read the original article
Hit count: 280
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.
© Server Fault or respective owner