Microsoft KB Archive/834116

= You receive error 16805 when you run the sp_makewebtask system stored procedure =

Article ID: 834116

Article Last Modified on 1/8/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
When you connect to Microsoft SQL Server 2000 by using domain user account credentials and run the sp_makewebtask system stored procedure, you may receive the following error message:

Server: Msg 16805, Level 11, State 1, Procedure sp_makewebtask, Line 125 SQL Web Assistant: Could not execute the SQL statement.

Note This problem may occur when the SQL Server service is running under the security context of a local Windows NT user account.



CAUSE
This problem occurs because the sp_makewebtask system stored procedure tries to determine what permissions the domain user account has. Because the local Windows NT user account is not permitted to obtain domain permissions, the procedure is not successful, and you receive the error message.



WORKAROUND
To work around this problem, use one of the following methods:
 * Method 1: Run the SQL Server service under the security context of a domain account that has administrative permissions on the computer that is running SQL Server 2000.

Note Microsoft does not recommend that you run the SQL Server service under the security context of a local administrator account.
 * Method 2: Connect to SQL Server 2000 by using a SQL Server login account that is a member of the sysadmin fixed server role, and then run the sp_makewebtask system stored procedure.

Note Microsoft does not recommend that you connect to SQL Server 2000 by using a SQL Server login account that is a member of the sysadmin fixed server role to work around this problem.



Steps to Reproduce the Problem
To reproduce this problem, follow these steps:  Log on to a computer that is running SQL Server 2000. Create a local Windows NT user account that is named User1, and then add the user to the Windows administrator group on the computer. Run the SQL Server service under the security context of User1. Create a domain user account that is named < >\< > . Add the domain user account to the sysadmin fixed server role. Log on to the computer that is running SQL Server 2000 by using the domain user account credentials.</li> Start SQL Query Analyzer, and then connect to SQL Server 2000 by using Microsoft Windows authentication.</li>  Run the following Transact-SQL statement in SQL Query Analyzer: USE pubs GO EXECUTE sp_makewebtask @outputfile = 'C:\MULTIPLE.HTM', @query = 'SELECT title, price FROM titles SELECT au_lname, au_fname FROM authors SELECT pub_id, pub_name FROM publishers SELECT au_lname, au_fname FROM authors', @dbname = 'pubs', @rowcnt = 5, @whentype = 9 GO </li></ol>

Note The sp_makewebtask system stored procedure may not be successful, and you may receive the error message that is mentioned in the &quot;Symptoms&quot; section.

Keywords: kberrmsg kbstoredproc kbservice kbsysadmin kbdatabase kbprb kbauthentication KB834116

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.