MS SQL Server Database Question

[Merrik]

Hi,

Does anyone know the best way to have an application update a remote MS Sql Server database on a domain?

I want all domain users to have write access.

I tried using a Windows Service, though this wasn't successful. I want to avoid using a typical domain account, due to the fact that passwords change frequently and this would be an administration nightmare for a Windows service that was installed on numerous computers.

I'm stumped at the moment. Any input is appreciated.

There must be solution, as I know several desktop applications/processes that communicate with database servers.

[DeltaRocked]

Hi ,

1: Do you want to add / modify / delete records by accessing the SQL server from a script / application running on a remote machine?

regards

[Merrik]

I need write log information to the remote database. So I need to write to the remote database.