Are you looking up against (pulling) most of those 100-300K records or just small portion of it
Are you looking up against (pulling) most of those 100-300K records or just small portion of it
I have the following issue that i can't seem to "fix":
I have 2 instances: Instance A (primary databases for my application) and Instance B (relational databases for Reporting Services).
Each instance is installed on a separate machine and both are included in the same domain.
I can access Instance A from Machine B and i can access Instance B from Machine A (with both SQLServer Authentication and Windows Authentication)... no problem here.
I've created a Linked Server connection from Instance B to Instance A without a problem. I can access all my databases from instance A in this linked server.
The problem is creating Linked Server from Instance A to Instance B. I get no error creating it, but i can't access any databases from Instance B.
I get the following error: Login Failed for user 'NT AUTHORITY\ANONYMOUS LOGON' (Microsoft SQL Server, Error: 18456).
I've been reading about this in some forums but no solutions seem to help...
This is most likely caused by the SPN on InstanceB not being set.