Jump to content

Update a database


Recommended Posts

Hi,

I'm working a Windows Service for desktop computers and the service needs to update a database. I'm wondering if anyone has tried this and can help.

I have created the service, but I want to avoid a network account to run the service, since network passwords change.

Progams like McAfee ePO update databases, though I'm not sure how.

Any help or insight would be really appreciated.

I though about NT Authority\NetworkService. But I think this is a local account to the PC, and you would have to add this computer account to the database for it to work - though I could be wrong.

When I tried to run the service as NT Authority\NetworkService I got a 14001 error: "This application has failed to start because the application configuration is incorrect. ...."

Yet it works fine running as a local service

Link to comment
Share on other sites

Where is the database, relative to the computer running the service? On the same computer, a server in the same domain, a remote web server, or what?

:unsure:

Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law
Link to comment
Share on other sites

Where is the database, relative to the computer running the service? On the same computer, a server in the same domain, a remote web server, or what?

:unsure:

The database is on a MS SQL Server on the domain. The service will be on a desktop PC on the same domain. Ideally I hope to install the service on numerous Desktop PCs.

Link to comment
Share on other sites

Just use a domain account created just for running that service. Make that account an SQL user with access to the DB, and have the service script use ADODB connections to update the database.

:unsure:

Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...