You are here: Execute an schedule job from MSDE with LINKED servers in SQL Server « MsSQL Server « IT news, forums, messages
Execute an schedule job from MSDE with LINKED servers in SQL Server

Posted by rkershberg@gmail.com on 10/16/06 22:57

I have a schedule job that I would like to run on a MSDE database. The
stored proc executes just fine if I run it manually. But trying to
schedule it through the Enterprise Manager (or Management Studio)
generates an error saying the the "Remote Access not allowed for
Windows NT user activated by SETUSER.

Essentially I have tables in the MSDE which are being updated based on
tables from a LINKED SQL Server.

I can not appear to get this job to execute unattended.

Please advise,

Rob
(rkershberg@gmail.com)

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация