>>>>>Hi
>>>>>
>>>>>I want to create a specific user to be used by a web service so any amendments by the web service in the database are tagged with that userid. (at the moment everything is going under sa)
>>>>>
>>>>>When I run a create user command I get an error.
>>>>>
>>>>>Windows NT user or group 'DEV01\Test.User' not found. Check the name again.
>>>>>
>>>>>What do I need to do (or a link to a good summary) to make this happen.
>>>>
>>>>Do you mean that you just want a single user account for all hits on the web service or that you want to narrow it down to the specific user who is accessing the service ?
>>>
>>>Hi Viv
>>>
>>>I would like a single account for all hits on the web service to differentiate changes to the database via the web service from changes via the in house system
>>
>>Then I guess the answer depends on how IIS (I'm assuming that's what is hosting the web service) is configured and how much control you have over it. Some options:
>>
>>1. Configure the relevant application pool to use a specific user.
>>2. If possible use a nested web.config to specify the user
>>3. Code the relevant user impersonation into the web service
>>
>>See
http://support.microsoft.com/kb/306158?wa=wsignin1.0 for examples of the two latter approaches....
>
>Thanks Vicv
>
>any idea what craig was getting at ?
Hi Nkolas :-}
Other than the obvious risks of allowing anonymous access (DOS attack) no....
Of course I'm assuming SQL commands cannot be directly acted on by the web service....