[Last Call] Learn how to a build a cloud-first strategyRegister Now


Connecting to a domain

Posted on 2011-10-18
Medium Priority
Last Modified: 2012-05-12
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".
Question by:Mr_Shaw
  • 3
LVL 34

Accepted Solution

Paul MacDonald earned 2000 total points
ID: 36985783
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.

Author Comment

ID: 36985983
can i used something like EXECUTE AS LOGIN with an AD account to solve this problem?

Author Comment

ID: 36985998
I just ran SELECT SUSER_SNAME() and it retuned my AD account....?

Author Closing Comment

ID: 36986155

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question