I have setup SQL Agent Job to run store procedures. I have linked server connection for source. When i run job i m getting following error.
"Invalid connection string attribute". [SQLSTATE 01000] (Message 7412).
EXECUTE AS USER' failed for the requested user.
Can somebody let me know what credentials do we need to have for linked server and SQL Agent job to run.
Thanks for help.
The following kb article deals with this issue:
Kalman Toth Database & OLAP Architect
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?