SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Linked Server Access Error from SQL Agent Job
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

learntsql
Aged Yak Warrior

India
515 Posts

Posted - 10/13/2010 :  02:57:54  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 10/13/2010 :  08:13:28  Show Profile  Visit russell's Homepage  Reply with Quote
sql agent account needs permission on linked server
Go to Top of Page

learntsql
Aged Yak Warrior

India
515 Posts

Posted - 10/13/2010 :  08:23:21  Show Profile  Reply with Quote
Thanks russell,
Sorry could you please explain bit more.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 10/13/2010 :  08:36:48  Show Profile  Visit russell's Homepage  Reply with Quote
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
Go to Top of Page

learntsql
Aged Yak Warrior

India
515 Posts

Posted - 10/13/2010 :  09:02:47  Show Profile  Reply with Quote
ThankQ very much.
its worked.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000