I have a situation where I have numerous workstations that will be running a system service that will both read and write values to a database on a SQL Server. The system service, running under the very permissive LOCAL SYSTEM account (required for the purposes of my application), presents a security issue that I would like to resolve by constraining it's access to the server through a limited user account. I do not want this service to login as LOCAL SYSTEM.
Can this be done? If so what would the connection string look like?
The system service was written in VB.Net and the connection string will have to be hard-coded in as the service runs without any user input.