Jump to content
  • Advertisement
Sign in to follow this  
johnnyBravo

[web] (sqlserver)enabling sp_makewebtask?

This topic is 4515 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

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

Share this post


Link to post
Share on other sites
Advertisement
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.).

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!