Hi craig

I'm not doing anything :-)

I'm doing some work at a site where they have web site built by a third party.

The web site is using a web service to access and update a SQL Server database (at the moment using the sa account)

They want to be able to track changes made via the web service.

So I suppose two questions.

Why do you say what you say and how is that relevant to this.

and

how do they set that up.

Thanks





>Please don't tell me you exposed a SQL Server web service to the Internet.
>
>>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.
>>
>>Thanks
>>
>>Nick