try running the cf service logged in as an admin account rather than local system account ----- Original Message ----- From: "James Blaha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 02, 2003 9:53 AM Subject: Help SQL Sever CFSTOREDPROC Issue.
> Hello All: > > I need some help please! > > Im using a couple of neat stored procedures to call a DTS package and > write the output to a UNC path. My issue is that it only works when I > output to my local SQL server hard drive or output to the UNC path by > executing the DTS package from my SQL server Enterprise Manager. If I > try to execute the CFSTOREDPROC from my CF server that goes to the UNC > path a get an error from the SQL server. All permissions have been set > to gives the 3 machines rights for read and write access. > > Any Ideas? > > Regards, > James Blaha > > > > These are the stored procs. > http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS > > > <CFSTOREDPROC PROCEDURE="spExecuteDTS" DATASOURCE="xx" debug="YES" > returnCode = "Yes"> > <cfprocresult name="importData"> > > <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname= "@Server" > value= "mySqlServer" null="no"> > > <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname= "@PkgName" > value= "DTS_HR" null="NO"> > > <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ServerPWD" > value="xx" null="NO"> > > <!--- Note: If you ran this with a local SA account you will need the > line below. ---> > <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" > dbvarname="@IntSecurity" value="1" null="NO"> > > </CFSTOREDPROC> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
