Sign in to follow this  

[web] (sqlserver)enabling sp_makewebtask?

This topic is 4242 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
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

This topic is 4242 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.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this