Unable to Run as Scheduled Task

[tvprasad]

Hi @everyone,
cc: @fretje

I've developed a .NET WebAPI using the dotnet-webapi-starter-kit and Microsoft SQL Server Express. When I start the program manually, it works perfectly. However, when I run it as a scheduled task, it fails to establish the SQL Server database connection and stops. Has anyone experienced this issue? Any advice would be greatly appreciated.

Thanks!

[fretje]

Why are you starting it as a scheduled task, and not as a service?

I would think that it's a user related issue... are you using a connectionstring with integrated security? Then it's the "current user" that is used, and when you start it as a "scheduled task" then it runs under the system account if I'm not mistaken...

[tvprasad]

@fretje , I am using Integrated Security and have added a Windows user login to SQL Server with the necessary permissions. However, I am encountering the same issue when running it as a hosted service. My ultimate goal is to run it as a hosted Windows service and get the WebAPI up and running.
Do you have any advice on how to use it as a Windows Service?
Thanks for your prompt response.

[fretje]

Is IIS not an option? That's usually the easiest when deploying on windows...

Otherwise just using the regular tools built into windows to register/run services... just be sure to add the right account to Sql Server (it can be the machine account in some cases)... as a last resort, you can use a connectionstring with username/password... that should definitely work...

[tvprasad]

I'm attempting to steer clear of relying on outdated IIS. I managed to transition to a Hosted Windows Service instead. However, I'm encountering a setback where the service fails to start during the initialization of the Database service, as illustrated in the screenshot.

Update:

I've successfully debugged and pinpointed the root cause. It turns out that the exception raised by UseFileStorage is due to a missing path.