November 26, 2004 at 12:50 pm
We have SQL 7.0 on W2K that has been running sp_RunWebTask that writes the ouput file on a network share for years.
When we try the same thing on W2K3 / SQL 2000, the sp_RunWebTask cannot access the share.
Both SQL 7 & SQL 2000 are running as Domain Admin.
Any help would be appreciated.
November 26, 2004 at 1:59 pm
What error messages did you get?
November 26, 2004 at 2:40 pm
The error comes up when sp_MakeWebTask is run to create and then run the WebTask.
The sp_MakeWebTask gets the error - unable to access file - template. (if I copy the template file to the local server, then the error is reported against the output file. If both template & output files are on LOCAL server, then the task runs fine).
Here is what I am runing in Query analizer:
EXECUTE sp_makewebtask @outputfile = N'W:\sites\ww\default2.asp', @query=N'EXECUTE [WWWServices2]', @templatefile=N'W:\sites\ww\default.tpl', @dbname=N'WWWServices', @whentype=9,@procname=N'web_task_WWWServices2',@codepage=65001,@charset=N'utf-8'
The "W" drive is a network drive on another server.
November 26, 2004 at 2:50 pm
Try to use UNC path.
EXECUTE sp_makewebtask @outputfile = N'W:\sites\ww\default2.asp', @query=N'EXECUTE [WWWServices2]', @templatefile=N'\\yourservername\sharename\sites\ww\default.tpl', @dbname=N'WWWServices', @whentype=9,@procname=N'web_task_WWWServices2',@codepage=65001,@charset=N'utf-8'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply