Windows task scheduler wont write to SQL database

Question

0.00/5 (No votes)

See more:

Hello

This is something ive never done before so i apologise if this is a silly question.

I have a c# console app which when ran locally it works perfectly. However, when I try and run it from task scheduler part of it runs but it wont write to the SQL database.

My folder has permissions to read and write. Also the task is running as administrator and with the highest privileges. When I check the task history it says its complete with no errors.

Any help would be appreciated

Thanks

What I have tried:

My folder has permissions to read and write. Also the task is running as administrator and with the highest privileges.  When I check the task history it says its complete with no errors.

Posted 15-Jan-19 0:06am

Member 12285600

Updated 15-Jan-19 5:08am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2019-01-15T05:09:00

One reason causing this could be difference in authentication. If you're using Windows authentication for SQL Server then when you're running the application from Windows session it's using your credentials. When you're running it using Task Scheduler you define which credentials are used.

So instead of using administrator account, perhaps you can use your account setting or if necessary create a separate account which will be used for the scheduled task.

Just to prevent misunderstandings, writing to a SQL database does not require access to the folders containing the database files. Typically these folders are not even visible to users of the database.

What comes to the outcome of the program, Task Scheduler shows if the application has execute successfully or not.You need to 'publish' the errors one way or another for them to be visible from outside. For example you can
- use a return code for the application
- write to a log file
- write to event log etc..

RickZeeland · Answer 2 · 2019-01-15T00:32:00

Solution 1

If this is about SQL Server, you probably need to add administrator as a user or modify the settings, see article here: Create a Database User - SQL Server | Microsoft Docs[^]

Posted 15-Jan-19 0:32am

RickZeeland