dtsrun and Error -2147467259 (80004005)

• Harp

  SSC Rookie

  Points: 47

  More actions

  February 13, 2007 at 1:13 pm

  #72623

  I always get the following error:

  Error -2147467259 (80004005); Provider error: 17 (11)

  [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

  from Microsoft OLE DB Provider for SQL Server.

  I do have sqlserver2005 running in a 64 bit machine (MSserver 2003). I did create a task here and have been trying to execute it from another machine (32 bit machine). I did install all needed in this second machine. I do get the error message while trying to run it with this command (in 32 bit machine)

  "dtsrun /S servername /E trustedUser /N package_name".

  NB: I have also changed the server authentification from

  windows-authentificationmodus to sql server- and windows

  authentificationmodus as I did read from this forum ... all to no avail. I have also tried with /Uusername and /Ppwd instead of /E...no success.

  What next am I still missing?

• Terry-239890

  Ten Centuries

  Points: 1387

  More actions

  February 15, 2007 at 5:16 pm

  #690108

  I know this is very silly question but could you PING to the 64 bit machine from the 32 bit machine? Because I could not find any other suggestion.

• Harp

  SSC Rookie

  Points: 47

  More actions

  February 17, 2007 at 12:13 am

  #690355

  Thanks for your reply: I was able to ping it successfully and I have also tried to use the IP-Adress instead of the servername... to no avail...

   

• Harp

  SSC Rookie

  Points: 47

  More actions

  February 20, 2007 at 9:37 am

  #690695

  Now I have created a task in server running at 32 bit machine and have been trying to execute it (using command line), but no success...

  I now get the follwing error message:

  Error: -2147467259 (80004005); Provider error: 17 (11)

       Error string:

       Error source:

       Help file:

       Help context: 0

  Any ideas or help as to what to do???

  Thanks in anticipation