asked on

SQl Job

Hello,
I have a SQlJob which is working fine in one sever.When we move to another server,it is failing.Here is the error I am getting:

OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for... Process Exit Code 2. The step failed.

This is very urgent.Please help.

Thanks

Colosseo

Assuming that the Job is using conneciton objects are you updating them with the name of the new server?

Scott

justin11

ASKER

Yes. When I execute the dtsPackage directly it runs fine. It gives this error when I try to schedule it as job and try to run it
Thanks

Anthony Perkins

>>It gives this error when I try to schedule it as job and try to run it<<
Is the account for the SQL Server Agent service a domain account?
What does your package do?

justin11

ASKER

How can I check whether it is a domain account?

It updates some tables in a linked server

Anthony Perkins

>>How can I check whether it is a domain account?<<
In the SQL Server Agent Properties, General Tab it would show "This account" with somthinng like this "YOURDOMAIN\USERNAME"

Sirees

Is the linked server created on new server? If so, check for security settings of linked server..

Anthony Perkins

Ah yes, very good point.

justin11

ASKER

Hello,

In the general tab service startup account is grayed out. I did check the security setting for linked server.It is ok

Do I need to create a proxy account for the agent.Any idea?

Thanks

Sirees

>>In the general tab service startup account is grayed out<<

Does this mean it is using a system account?? I think you should use a domain account for SQl Server Agent

justin11

ASKER

Please let me know how to use a domain account. That button is completely grayed out.

Thanks

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial