RE: sp_runwebtask remote access error

From: John (jlee_at_heartlandis.com)
Date: 07/02/03 

Date: Wed, 2 Jul 2003 06:23:22 -0700

Vikrant,

Did you find out if there was a bug for this issue?

>-----Original Message-----
>
>Hello John,
>
>Since SQL 2K SP3, sp_makewebtask (xp_makewebtask) is
calling
>sp_setuserbylogin (=SETUSER)
>and that prevents a linked server query from being called
within the sproc
>giving the error you are experiencing.
>
>Although its a behavior by design , there has been a bug
filed and I will
>look into it for the current status.
>
>Meanwhile, the suggessted workaround is to create a
global TempTable ,
>fill it with the results of the linked server
>query and then use the local Query instead of linked
server query for
>creating the webtask.
>
>Thanks,
>
>Vikrant Dalwale
>
>Microsoft SQL Server Support Professional
>
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Get secure !! For info, please visit
http://www.microsoft.com/security.
>Please reply to Newsgroups only.
>
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "John" <jlee@heartlandis.com>
>| Sender: "John" <jlee@heartlandis.com>
>| Subject: sp_runwebtask remote access error
>| Date: Wed, 25 Jun 2003 11:31:55 -0700
>| Lines: 13
>| Message-ID: <03eb01c33b48$0dd3bc10$a101280a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Thread-Index: AcM7SA3T1f7ABbtFT8WgNewkPacgHw==
>| Newsgroups: microsoft.public.sqlserver.security
>| Path: cpmsftngxa06.phx.gbl
>| Xref: cpmsftngxa06.phx.gbl
microsoft.public.sqlserver.security:14161
>| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
>| X-Tomcat-NG: microsoft.public.sqlserver.security
>|
>| We have a SQL2K SP3 server on W2K that is having
>| difficulty running web tasks. The task simply executes
a
>| stored procedure. This procedure does a distributed
query
>| and works fine when it is in a job itself or in QA.
>| However, as soon as I create a web task that executes
this
>| procedure, I get errors. I have checked that the
service
>| logon account is even a Domain Admin. Any thoughts?
>| Server: Msg 7410, Level 11, State 1, Line 0
>| Remote access not allowed for Windows NT user activated
by
>| SETUSER.
>| Server: Msg 16805, Level 11, State 1, Procedure
>| sp_runwebtask, Line 26
>| SQL Web Assistant: Could not execute the SQL statement.
>|
>
>.
>

Relevant Pages

  • Re: SQL linked server with ODBC
    ... and then run the query. ... I am having trouble extracting data from a Navision ... I am using sql server 2000. ... I created a linked server using OLE DB provider ...
    (microsoft.public.sqlserver.odbc)
  • Temp table from text file connected via Linked Server
    ... I have a text file as a table in a linked server. ... statement to query the file, changing the name of the file. ... SELECT TextFile.* ... DECLARE @strFileName varchar ...
    (microsoft.public.sqlserver.programming)
  • Re: Error with Linked Servers
    ... is it large set data you want to return? ... But the problem isn't so much in the query it's the fact that when you ... select the linked server the system hangs with no error message and the ... the session hangs and no error message is displayed. ...
    (microsoft.public.sqlserver.security)
  • Re: problem with Execute SQL Task
    ... I found out that the problem for the failure is due to a linked server query ... i did in my batch query. ... If this DTS package is run manually it works but when i schedule it to run ...
    (microsoft.public.sqlserver.dts)
  • Re: IS NULL not working in WHERE clause.
    ... At this point it's pretty hard to say whether it's a bug or corruption. ... And just to be certain - you said the query operators each select ... in the query plan that checks time_id for null, ... >This execution plan shows a single execution string. ...
    (microsoft.public.sqlserver.programming)