<div>
could you please elaborate. how do i do that? Thanks
</div>


could you please elaborate. how do i do that? Thanks

<div>
check this <br />
<a href="http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/" rel="ugc">http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/</a>
</div>


check this
http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/ [http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/]

<div>
One of the SQL server is 2012 and the other 2008 would that cause any problems?
</div>


One of the SQL server is 2012 and the other 2008 would that cause any problems?

<div>
Never tried that, but it shouldn't be an issue; the issue here is the permission.
</div>


Never tried that, but it shouldn't be an issue; the issue here is the permission.

<div>
We use SPNs on all our environments
</div>


<div>
are the 2 sql servers part of the same domain?<br />
is your login (windows login) also defined on the other server?<br />
what is the linked servers configuration in the login mapping tab?<br />
is the local sql server service account &quot;local system&quot; or a domain account?
</div>


are the 2 sql servers part of the same domain?
is your login (windows login) also defined on the other server?
what is the linked servers configuration in the login mapping tab?
is the local sql server service account "local system" or a domain account?

<div>
<div class="content wysiwyg-content">
When I run a sql query to select records from a db / table that resides on a different server from the one I am connected to, I get the error :<br />
NT AUTHORITY\ANONYMOUS LOGON<br />
<br />
I am logged in with my windows credentials and I have access to both th servers.
</div>
</div>


When I run a sql query to select records from a db / table that resides on a different server from the one I am connected to, I get the error :
NT AUTHORITY\ANONYMOUS LOGON

I am logged in with my windows credentials and I have access to both th servers.

Select query on a different sql server

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.

Microsoft SQL Server

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.