>>>>>>>>>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?