Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
learntsql
524 Posts |
Posted - 2010-10-13 : 02:57:54
|
Hi All,I created One Linked Server to access another SQL Server.I am able to access this from StoredProcedure but when i configure this SP as job; job execution is failed.saying error as "Invalid authorization specification". [SQLSTATE 01000] (Error 7412). The step failed. |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-13 : 08:13:28
|
sql agent account needs permission on linked server |
|
|
learntsql
524 Posts |
Posted - 2010-10-13 : 08:23:21
|
Thanks russell,Sorry could you please explain bit more. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-13 : 08:36:48
|
What security context are you using in linked server?if it is "Current Securiity Context" then the Service account running SQL Agent needs to be granted permission on the linked server.If you have listed specific accounts to map, then this account needs to be mapped as well.Right-click the linked server, click properties and go to the security tab to see this.Use the services applet to view the SQL agent service account |
|
|
learntsql
524 Posts |
Posted - 2010-10-13 : 09:02:47
|
ThankQ very much.its worked. |
|
|
|
|
|