I have an NT service which opens an SQL SERVER database using ADO. To
open the database I need a UID and PWD. Since, I am running it from an
NT service I can't display any dialogbox. One way to solve this is to
hard code the UID and PWD in the code OR to store it in the registry.
Obvisouly, this is unacceptable.
One way I can see of solving this, is to, start the service in a user
account (not System Account) and use this security context to open the
database. Unfortunatly, I can only have the SID and there is no way of
using SID to open database.
Got any better solution?