Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


TVSeries31
2012-11-17T16:45:02Z
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!
Sponsor
Forum information
TVSeries31
2012-11-17T16:53:02Z
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.
TVSeries31
2012-11-17T17:02:22Z
It was all permission issues. I needed to Grant permissions to user 'NT AUTHORITY\SYSTEM' within SQL Server.
Support
2012-11-17T19:18:25Z
Originally Posted by: TVSeries31 

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).
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
TVSeries31
2012-11-17T19:36:02Z
Oh Ok! Great to know. Thanks!
Scroll to Top