Connecting to a domain

Posted on 2011-10-18
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 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
    LVL 33

    Accepted Solution

    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

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

    Author Comment

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

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now