SQL Server Performance

Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Discussion in 'Getting Started' started by shail87, Jan 6, 2009.

  1. shail87 New Member

    Hi All,
    Yesterday one of my jobs failed and from the job history i got the message below could you please anyone help me out to solve this issue
    Server SHSQLFILT01
    Job Name Transfer SNs (and returns) to Shipley
    Step Name Transfer HU
    Duration 00:00:42
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0
    Message
    Executed as user: FILTRONICzsqlservice. ... DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun 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 Error: -2147220440 (80040428); Provider Error: 0 (0) Error string: Package failed because Step 'DTSStep_DTSExecuteSQLTask_1' failed. Error source: Microsoft Dat... Process Exit Code 1. The step failed.
  2. satya Moderator

  3. shail87 New Member

    i had gone through this url and find the network connectivity issues but both of my servers pinging each other still my jobs fails please find the DTD Package which
    may have issues:--DTSRun /S "shsqlfilt01" /N "Transfer Foreign Returned Serial Numbers (new to new)" /A "Customer":"8"="Filtronic Comtek" /A "CustomerFacility":"8"="Filtronic Shipley" /A "ChildErrorDesc":"8"="Failed to create children of this serial number" /A "EX_Database":"8"="ATE" /A "EX_Server":"8"="10.86.5.10" /A "EX_UserName":"8"="snimporter" /A "EX_Password":"8"="sn1mp0rter" /A "IM_Database":"8"="ate" /A "IM_Server":"8"="shsqlfilt01" /A "IM_UserName":"8"="snimporter" /A "IM_Password":"8"="sn1mp0rter" /A "Workflow":"8"="Made In Suzhou" /A "SNErrorDesc":"8"="Serial number not found on foreign database" /A "TCVErrorDesc":"8"="Failed to create foreign serial number" /A "DefaultDespatchStartDate":"7"="01/01/2004" /A "FailedToRegisterDesc":"8"="Could not add this serial number to a return" /A "InitialStatusDesc":"8"="Information Complete" /W "0" /E
  4. satya Moderator

    Check the DTS package properties such as SOURCE and DESTINATION SQL Server names, try to connect the same from Query Analyzer and OSQL too.
    I believe the problem seems to be the connectivity with the name specified in the dts package.

Share This Page