SQL Server Performance Forum – Threads Archive
Unable to Schedule DTS, Giving error (Not Associte
I have created one DTS in sql server 2000 (using OS Windows 2003 server) that will copy records into database on another system (Windows XP). When i execute this DTS from enterprise manager it works fine but when i schedule this DTS to run in every 1 minute from enterprise manager only, then it will give me an error in log file "Step Error Description:Login failed for user ‘sa’. Reason: Not associated with a trusted SQL "…..Plz help me out as i am creating this DTS first time and it’s very urgent as i am trying to found the solution since last 1 week but in vain… any help is highly appreciated. with regards
ashish
quote:Originally posted by jainashish
it will give me an error in log file "Step Error Description:Login failed for user ‘sa’. Reason: Not associated with a trusted SQL "…..
Add this statement: "Integrated Security=SSPI;" after Initial Catalog and try.
Surendra Kalekar
Hi Surendra, Thanks for such a quick response, plz can u ellaobrate in detail as i am not much aware of sql server itself. where can i find initial Catalog and what does it do. thanks in advance
with regards
ashish
quote:Originally posted by jainashish
Hi Surendra,
Thanks for such a quick response, plz can u ellaobrate in detail as i am not much aware of sql server itself. where can i find initial Catalog and what does it do.
thanks in advance
with regards
ashish
That you have to add in the connection string. Read BOL for more about DTS and connection string.
Surendra Kalekar
with regards
ashish
Sounds like you are running your sql server in Windows Authentication mode and not Mixed SQL / Windows. So it works when you run it manually as MYSERVERAdministrator but not scheduled as ‘sa’. Either switched to mixed authentication mode or schedule the job to run with the sql service windows account.
Hi Argyle, On both of the computer’s i am using Mixed mode only. thanks in advance
ashish
See if connection string is correct www.ConnectionStrings
and also check the DTS Coding at www.sqldts.com
Madhivanan Failing to plan is Planning to fail
You can even try this.
Create a procedure to run the DTS using dtsrun utility and then create a job to run the procedure using T-SQL task in job. Check whether this SP runs DTS perfectly or not.
Now i made a DTS and creating the job to run that DTS file using dtsrun utility(dtsrun /F
"C
TSew_ashish.dts" /n "testing") but still i am getting the error.. "The job failed. The Job was invoked by User sa. The last step to run was step 1 (DTS package)" plz help me out with these errors. Regards & Thanks
ashish
]]>