Re: DTS Job Error: Invalid connection

Tech-Archive recommends: Fix windows errors by optimizing your registry

Looks like the DTSRUN command created in the job step has some bad
connection information.

When using the schedule package function it generates the command line using
the security info held in your local Enterprise Manager registration. This
may not be valid on the server itself, for example a server name may not
reolve correctly if there are aliases used or different name resolution
servers between teh EM client and the server itself.

Manually create the command line (DTSRUNUI), to be sure of what is used.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Venkat" <nospam_venkat_asp@xxxxxxxxxxx> wrote in message
news:emcnf5qaFHA.4040@xxxxxxxxxxxxxxxxxxxxxxx
> Hi folks,
>
> I created a DTS package on a SQL Server and Scheduled it by right
> clicking on that package. After that I have changed the owner of the job
> to 'sa'.
> The job fails with error: DTSRun: Loading... Error: -2147467259
> (80004005); Provider Error: 14(E) Error string:
> [DBNETLIB][ConnectionOpen (Invalid Instance()].]Invalid connection.
> Error source: Microsoft OLE DB Provider for SQL Server
> Help file: Help Context: 0. Process Exit Code 1. The step failed.
>
> Here is the additional info:
> 1. I have logged into the SQL Server from another machine thru EM using
> a SQL Server login which has sa access.
> 2. When I saved the package, EM shows my windows login as Owner of the
> package (but i connected to SQL Server using my SQL Server login that
> has sa access).
> 3. When a user (who has local admin access to the SQL Server box)
> schedules the job, it works well.
>
> Is it a must to have Local Admin rights to schedule a DTS package.
>
> Any ideas...
>
> Thanks in advance.
> -----
>
> *** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: Scheduled Task problem...
    ... I'd save the command in a batch file and schedule that. ... If the job connects to another machine you may need to add the user/ group 'logon as batch job' rights. ... serverName (this is the server\instance name for SQL Server) ...
    (microsoft.public.windows.server.general)
  • Re: Scheduling a simple local package wont stick
    ... Well my domain account is the owner, and it is member of the local ... Where do I find out if this Sql server service account has the necessary ... - When you run the DTS package yourself, it runs with your credentials, ... DTS packages do not retain a schedule. ...
    (microsoft.public.sqlserver.dts)
  • Scheduling DTS Packages on 64-bit SQL Server
    ... a DTS package on a 64-bit SQL Server installation. ... schedule the package in SQL Server Enterprise Manager is disabled. ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling DTS job
    ... Local System account has unrestricted access to the local box and cannot see ... The day schedule took just as long as overnight right? ... Would this take as long "SQL Server to SQL Server"? ... package involved data transferred from sybase to ...
    (microsoft.public.sqlserver.dts)
  • Re: Restart Services
    ... How to restart SQL Server at regular intervals? ... > After that schedule this batch using the Windows scheduler or use the AT ... > See the help of AT command by executing the below from command prompt:- ... >> Do you want to stop the services so that you can backup your databases? ...
    (microsoft.public.sqlserver.clients)