Home Forums SQL Server 2005 Administering MS Access as linked server : job fails RE: MS Access as linked server : job fails

  • March 5, 2008 at 5:09 am

    #785400

    SQL ORACLE (3/4/2008)

    How about to change the execution account to others, such as local account?

    Try this.

    1. Open the SQL Server Configuration Manager.

    2. For the SQL Server Agent process, change the 'Log On As' from Local System to a local account.