🔒 Locked

[web] (sqlserver)enabling sp_makewebtask?

Started by johnnyBravo Jun 6, 2006 at 8:09 AM 0 replies 4.6k views

Original Post

johnnyBravo

141

johnnyBravo

Jun 6, 2006 at 8:09 AM

Hi, i'm trying to use sp_makewebtask, but it gives the error:

Quote:
Msg 15281, Level 16, State 1, Procedure xp_makewebtask, Line 1 SQL Server blocked access to procedure 'sys.xp_makewebtask' of component 'Web Assistant Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Web Assistant Procedures' by using sp_configure. For more information about enabling 'Web Assistant Procedures', see "Surface Area Configuration" in SQL Server Books Online.

How do i enable it? I've used:


EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE WITH OVERRIDE;
EXECUTE sp_configure 'xp_cmdshell', '1';
RECONFIGURE WITH OVERRIDE;
EXECUTE sp_configure 'show advanced options', 0;
RECONFIGURE WITH OVERRIDE

to enable xp_cmdshell. could i use something similar for sp_makewebtask? thx

johnnyBravo

Author

141

johnnyBravo

Jun 6, 2006 at 9:01 AM

well i worked out how to enable it:

EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE;
EXECUTE sp_configure 'Web Assistant Procedures', 1;
RECONFIGURE;

but I now get a dll error...

Quote:
Msg 17750, Level 16, State 0, Procedure xp_makewebtask, Line 1
Could not load the DLL xpweb90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

Topic Locked

This topic has been locked by a moderator. New replies are not allowed.