I have a job setup that queries a SQL Server database. This is the error I am getting.

Error in task sql: Cannot open database "database" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.

I am using SQL Server 2012 Compact edition
Windows Authentication

When I setup the connection in the 'connections' it tests successfully.

I have a different connection setup with all 3 data providers (odbd, oledb, mssql)
using a 'trusted connection', tried 'Connecting to a sql server instance', tried most of them..nothing.

In the SQL Explorer


When I double click, I get an error reading: Access to the path 'C:\Program Files(x86)\VisualCron\mssql.txt' is denied. PrintTable.

Could that be a permission issue? Any help is appreciated!

That was a permission issue. Should have researched more before posting. I am still getting the connection error described at the top of the post though.

It was all permission issues. I needed to Grant permissions to user 'NT AUTHORITY\SYSTEM' within SQL Server.

It was all permission issues. I needed to Grant permissions to user 'NT AUTHORITY\SYSTEM' within SQL Server.

Yes, and you can also use a Credential in the Task to run the whole query as another user (if using integrated security).

---

Oh Ok! Great to know. Thanks!