RE: sp_runwebtask remote access error
From: Vikrant V Dalwale [MS] (vikrantd_at_online.microsoft.com)
Date: 07/02/03
- Next message: Gary X: "Re: SQL security"
- Previous message: george d lake: "Re: Database set to Single User? How?"
- In reply to: John: "RE: sp_runwebtask remote access error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 02 Jul 2003 16:29:27 GMT
John,
Yes, there has been a BUG filed for this however, this is a behavior by
design since SP3. You might wanna consider the
workaround suggested in my previous post.
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>
| References: <03eb01c33b48$0dd3bc10$a101280a@phx.gbl>
<n4wpebGPDHA.2044@cpmsftngxa06.phx.gbl>
| Subject: RE: sp_runwebtask remote access error
| Date: Wed, 2 Jul 2003 06:23:22 -0700
| Lines: 84
| Message-ID: <3d9601c3409d$1c161c00$a601280a@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: AcNAnRwTty+lNTtlQ+WLEjZIVB1TZg==
| Newsgroups: microsoft.public.sqlserver.security
| Path: cpmsftngxa09.phx.gbl
| Xref: cpmsftngxa09.phx.gbl microsoft.public.sqlserver.security:2413
| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| 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.
| >|
| >
| >.
| >
|
- Next message: Gary X: "Re: SQL security"
- Previous message: george d lake: "Re: Database set to Single User? How?"
- In reply to: John: "RE: sp_runwebtask remote access error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
