Connecting to a domain

When using Service Broker I am getting the following message in a SQL Trace.

Could not obtain information about Windows NT group/user....

In the article http://flylib.com/books/en/1.514.1.69/1/ it says,

"Whenever SQL Server needs to authorize a user, it needs to connect to a domain controller if SQL Server doesn't have enough information cached for authorization. The only way to correct this problem is to connect to your domain".

What does it mean "connect to your domain".
Mr_ShawAsked:
Who is Participating?
 
Paul MacDonaldConnect With a Mentor Director, Information SystemsCommented:
Connect to a Domain Controller so it can validate the account in Active Directory.  This is the alternative to using accounts in SQL Server itself.
0
 
Mr_ShawAuthor Commented:
can i used something like EXECUTE AS LOGIN with an AD account to solve this problem?
0
 
Mr_ShawAuthor Commented:
I just ran SELECT SUSER_SNAME() and it retuned my AD account....?
0
 
Mr_ShawAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.