Server A doesnt have access to Mas90, so i have to fire off a stored procedure on a server that does have access to mas90...this will populate a table that...

did that end up being the problem? One is 32 bit and its trying to run a linked server against a 64bit version....BUT....it has no problems running other stored procedures...

Did anyone ever figure anything out with this? Im having the exact same issue.

I connect to server A running Sql and can execute my stored procedure that has a link...