I am trying to execute a stored procedure through ColdFusion. The stored procedure being executed attempts to insert local data into a remote server table through a linked server.
Attempting the stored procedure call from ColdFusion results in an error:
[Macromedia][SQLServer JDBC Driver]The DBMS returned an unspecified error. The command code was 253.
However, if the stored procedure is exected within SQL Server Management Studio, the call works correctly, no error.
I am using the same credentials within Management Studio as within ColdFusion (via Datasources).