September 9, 2013 at 9:06 am
Hi all, long time have not posted here.
here is brief description of the problem.
SSIS package, simple task to execute stored procedure. Server is a cluster with two nodes
, lets say, SQL 1 and SQL2
package executed from SQL2, and in this particular step acquires connection to SQL 1
Connection specified is .NetProviders/SQL Client Data Provider connection, uses AD account and windows authefication.
all rights are in place on both nodes for this user.
The exact SQL statement: Exec dbo.<procedurename>;
If i click on Test Connection in Connection box its successful.
Job is scheduled to run each morning and comes back with
Refresh Employee Execute SQL Task
Description: Failed to acquire connection "Temp ADO NET".
Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error Error: 2013-09-09 07:40:23.35
Code: 0xC00291EC Source: Refresh Equipment Execute SQL Task
Description: Failed to acquire connection "Temp ADO NET".
Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error Error: 2013-09-09 07:40:46.83
Code: 0xC00291EC Source: Refresh Address Execute SQL Task
Description: Failed to acquire connection "Temp ADO NET".
Connection may not be configured correctly or you may not have the right permissions on this connection.
E... Process Exit Code 1. The step failed.
Thank you for help in advance
September 10, 2013 at 2:39 am
If your job is scheduled by the SQL Server Agent you have to add the SQL Server Agent Service Account to your database. Check SQL Server Configuration Manager to check this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply