January 6, 2009 at 11:53 pm
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: FILTRONIC\zsqlservice. ... 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.
January 7, 2009 at 1:33 am
The problem is quite clear: SQL Server does not exist or access is denied
Seems this script transfers data to another SQL Server?
Check manually if you can make a connection to this server with the account used by this job to verify if permissions are causing this error.
Or check if this server was down / network was down during this job.
Wilfred
The best things in life are the simple things
January 7, 2009 at 2:02 am
Can you check if you able to ping the server?
Also try using the FQDN or IP address in the connection string than just the machine name.
January 8, 2009 at 4:38 am
I have checked its pinging please find the DTS package which may have problem
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
January 8, 2009 at 6:09 am
hi shail,
first answer me that do u try to run that dts package manually ....
to find out which package that job runing to to schedule job property you will found that package.
and you have to also tell me that r u using sql server 2000 or 2005 if you got the ping that one cause of this problem is from user who runing this job that don't have rights to access this particular package ... so for better understanding give me details abt what you are trying to do ....
Raj Acharya
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply