SQL Server Forums - Linked Server Access Error from SQL Agent Job

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

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

Topic

learntsql
Constraint Violating Yak Guru

India
458 Posts

Posted - 10/13/2010 : 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

USA
4964 Posts

Posted - 10/13/2010 : 08:13:28

sql agent account needs permission on linked server

learntsql
Constraint Violating Yak Guru

India
458 Posts

Posted - 10/13/2010 : 08:23:21

Thanks russell,
Sorry could you please explain bit more.

russell
Pyro-ma-ni-yak

USA
4964 Posts

Posted - 10/13/2010 : 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
Constraint Violating Yak Guru

India
458 Posts

Posted - 10/13/2010 : 09:02:47

ThankQ very much.
its worked.

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.