February 20, 2005 at 1:11 am
Hi,
I am having a problem when trying to run sp_makewebtask in SQL server 2000, service pack 3. There are two instances of SQL Server running on the computer, one runs under a domain account the other under a local account.
The problem that i am having is that i am trying to run sp_makewebtask on the machine that logs on under a local account, whenever i try and run the procedure i get the error "SQL Web Assistant: Could not execute the SQL Statement". So to get around this i tried to set up the sp_makewebtask procedure on the computer with the domain login and then run the sp_runwebtask in the database that uses the local logon. Then i get the following error "Remote access not allowed for Windows NT user activated by SETUSER". i have installed the hotfix from microsoft, but still the error occurs.
any help would be greatly appreciated.
Thanks
Tim
February 21, 2005 at 7:56 am
To generate the file the SQL Server needs rigths to write to device ( local drive:\... or network \\compName\ SharedFolder) wich have to be givem to the account under wich the SQL Server is started.
(NOT by the connection user!)
In order to run sp_makewebtask your account used to connect to SQL needs rigths to run it( if not sysadmin account)
Vasc
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply