<div>
Sounds like your SQL server service is running using NT Authority. &nbsp;Change the server to run using a domain account and it should work fine.
</div>


Sounds like your SQL server service is running using NT Authority.  Change the server to run using a domain account and it should work fine.

<div>
I suppose that [2008R2 server] is an existing linked server name, right?<br />
If so check the credentials configuration for that linked server.
</div>


I suppose that [2008R2 server] is an existing linked server name, right?
If so check the credentials configuration for that linked server.

<div>
<div class="content wysiwyg-content">
I am running a SQL query from SQL 2014 to SQL 2008R2. &nbsp;When I run the query for the SQL server will run fine. &nbsp;When I run it from my desktop I get the following error:<br />
<br />
Msg 18456, Level 14, State 1, Line 1<br />
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.<br />
When I look at the logs on the server that the query is connecting to this is the error I am getting:<br />
<br />
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON Reason: Token-based server access validation failed with an infrastructure error.<br />
<br />
Here is the query I am running. &nbsp;I am running from SQL 2014:<br />
<br />
SELECT * FROM [2008R2 server].CCMData.dbo.DimTim<wbr />e<br />
<br />
I am using my domain credentials.<br />
<br />
Thanks for any help.
</div>
</div>


I am running a SQL query from SQL 2014 to SQL 2008R2.  When I run the query for the SQL server will run fine.  When I run it from my desktop I get the following error:

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
When I look at the logs on the server that the query is connecting to this is the error I am getting:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON Reason: Token-based server access validation failed with an infrastructure error.

Here is the query I am running.  I am running from SQL 2014:

SELECT * FROM [2008R2 server].CCMData.dbo.DimTime

I am using my domain credentials.

Thanks for any help.

SQL query will work on SQL server SSMS but not on desktop SSMS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.