Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-11 : 08:46:46
|
| Helen writes "I am trying to run an sp_runwebtask procedure using MS SQL Scheduler and I am running into apparent permissioning issues I can not resolve.The web task itself is a simple select statement.The task, having been executed on the sql server, must write the resulting html file onto the web server. Both servers are running Win2000 OS, and sql server is version 8.00.194.I have local admin rights on both servers, but have only user rights on the network level.I have established a local user account on the web server identical to the sql server account used to install sql server software. I created a share on the web server and gave sql server account rights to it.After all this prep work was done, I was able to successfully execute sp_runwebtask from a SQL Analyzer. All my attempts to execute the same sp_runwebtask from within the Scheduler failed (as well as executing sp_start_job). I see that the job is being performed in the context of something called NT AUTHORITY\SYSTEM. (Can you tell me what it is and where did it came from?)My attempts to use SETUSER to overwrite it failed as well. Setting up a proxy account using xp_sqlagent_proxy_account did not help either.The ownership of the scheduler job itself does not seem to change anything.As I see it, the NT AUTHORITY\SYSTEM can not log into the web server (since it has neither a local account on the web server no a network login), and thus sp_runwebtask fails to executeIs there any way to overcome this predicament?ThanksHelen" |
|
|
|
|
|
Permissions issues with MS SQL Scheduler