March 14, 2003 at 1:03 pm
Quite recently we have applied SP4 and Update to SP4 on a SQL Server 7.0 Server. Now the version its showing is 7.00.1077. One of the jobs scheduled on this server is ... runwebtask job. This is how I am executing on a User database:
EXEC sp_runwebtask @procname = N'proc1'
This used to get executed very well earlier. All it does is create an HTML file locally on the server. Now this started FAILING with the following error:
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement. [SQLSTATE 42000]
Msg 0, Sev 0: Associated statement is not prepared [SQLSTATE HY007]
OR
Msg 16882, Sev 11: SQL Web Assistant: Web task not found. Verify the name of the task for possible errors. [SQLSTATE 42000]
Msg 0, Sev 0: Associated statement is not prepared [SQLSTATE HY007]
Please Help!!!!
Thanks & Regards,
Murali Damera.
SQL DBA.
.
March 17, 2003 at 8:00 am
This was removed by the editor as SPAM
May 2, 2003 at 9:13 am
This problem exists in sql2k with sp2 or 3 whereby the builtin/admins group ( which I usually disable ) must be enabled for the web assistant to work. Seems no matter how you set up SQL Server the web assistant has to connect as the domain Admin to work .. tried all the tricks I can think of to get it to work.
May 2, 2003 at 9:44 am
quote:
the builtin/admins group ( which I usually disable ) must be enabled for the web assistant to work.
You may try to grant 'NT Authority\System' to access SQL Server with 'sa' right.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply