RE: SSIS Scheduling Failure - AcquireConnection Error

Hi Eugene,

Thanks for the post!

From your description, my understanding of this issue is: You can manually
run your SSIS job but can not scheduled runing your job and get the
following error:

Error: 'The AcquireConnection method call to the connection manager
'conn_ORaccPublic_OLEDB' failed with error code 0xC0202009. '

If I misunderstood your concern, please feel free to let me know.

Please check what account your SQL Agent services is running.

You could do this in SQL Server Configuration Manager
1. In SQL Server Configuration Manager, expand SQL Server 2005 Services,
and then right-click the SQL Server Agent service instance you want to
configure.

2.On the Log On tab of the Service Properties - SQLSERVERAGENT dialog,
select the Log on as type. You can select one of the following:

- Select Local System account if your jobs require resources
from the local server only.
- Select This account if your jobs require resources across
the network, including application resources; if you want to forward events
to other Windows application logs; or if you want to notify operators
through e-mail or pagers.

The SQL Agent running account must be a windows account. Since you state
you could run this job correct if you log in using your account, I think
you could set the SQL Agent running account to be your account and check
this issue again.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Attach a sql2005 database at a different directory
    ... Use SQL Server configuration manager from SQL Server 2005 program ... If the account is not local system then change it to Local system and then ... I then try to attach it. ...
    (microsoft.public.sqlserver.setup)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)