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


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

<div>
I just ran SELECT SUSER_SNAME() and it retuned my AD account....?
</div>


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

<div>
<div class="content wysiwyg-content">
When using Service Broker I am getting the following message in a SQL Trace.<br />
<br />
Could not obtain information about Windows NT group/user....<br />
<br />
In the article <a href="http://flylib.com/books/en/1.514.1.69/1/" rel="ugc">http://flylib.com/books/en/1.514.1.69/1/</a>&nbsp;it says,<br />
<br />
&quot;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&quot;.<br />
<br />
What does it mean &quot;connect to your domain&quot;.
</div>
</div>


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".

Connecting to a domain

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.