October 25, 2014 at 8:19 pm
Here's my setup.
Server A: Teradata Database
Server B: SQL Server 2012
Server C: SQL Server 2012
Server B has a linked server to Server A using id/pwd for 3 users (myself, sa, and the service account running Server B). The id/pwd is a Teradata user id/pwd.
Server C has a linked server to Server B using id/pwd for 3 users (myself, sa, and the service account running Server C). The id/pwd is a sysadmin on Server B.
Server B & C are running under the same AD service account.
I'm trying to execute this statement from Server C
EXEC <Server B>.master.dbo.sp_executesql N'EXEC sys.sp_testlinkedserver <Server A>;';
The error I get back is that the id/pwd is incorrect to Teradata. I know that the linked server on Server B works just fine, so I'm assuming it has something to do with the execution context that is executing sp_executesql, but I'm not sure what that is.
Any ideas?
Ahhh, figured it out.
I didn't have the Server B SQL Server id mapped to the Teradata id/pwd in the linked server. Doh!
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply