>>>>>>>>>>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...
>>>>
>>>>Thanks
>>>>
>>>>excuse my typos. I put it down to the blow on the head ..
>>>
>>>I hope you are not serious ?
>>
>>No not really. I did have a few days of mixing word orders up while speaking which was weird and sleeping a lot.
>
>Like Viv I thought you might have literally suffered a blow on the head, like maybe while bicycling like a madman through London. It still doesn't sound so good, though. What's up?

Nick did get knocked off his bike by a car....