Skip to main content
Question

Problem setting upp scheduled task with SQL server connection using service account.

  • December 4, 2020
  • 2 replies
  • 246 views
E

Hi!

 

I´m having problems getting a scheduled task to run with a service account. I get the following error: 

2020-12-04 10:33:51|  0.7| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Opening `omnia_' for read operation
 
2020-12-04 10:33:51|  0.7| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server...
 
2020-12-04 10:33:52|  1.0| 0.3|WARN |Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Det gick inte att hitta den angivna providern. Den kanske inte Ã¤r ordentligt installerad.'. Connection string 'Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=;Initial Catalog=omnia_;User ID=;Password=********'
 
2020-12-04 10:33:52|  1.0| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Trying to connect using SQL Server 2012 Native Client...
 
2020-12-04 10:33:52|  1.0| 0.0|WARN |Microsoft SQL Server Spatial Reader: Failed to connect using SQL Server 2012 Native Client. Provider error '(-2147217843) Invalid authorization specification'. Connection string 'Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=;Initial Catalog=omnia_;User ID=;Password=********'
 
2020-12-04 10:33:52|  1.0| 0.0|ERROR |Failed to open reader

I have tried some measures such as making the connection public, logging in with the service account and starting FME. It works if i use a regular account (the account that created the workspace)

 

What seems to be the resolution to this issue?

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    2 replies

    daraghatsafe
    Forum|alt.badge.img

    Hi @eriblan​ 

    Thank you for your question, I would recommend checking out this article, there a few possible reasons for Provider error '(-2147217843) to appear. Let me know if this was helpful.

    Regards,

    Daragh

    milo89
    Enthusiast
    Forum|alt.badge.img+26
    • milo89Enthusiast
    • Enthusiast
    • December 6, 2020

    Hi @eriblan​,

    I've come across the same issue.

    In our instance the service account doesn't have the permissions that your regular account has. This is essentially what's mentioned in the article from @daraghatsafe​'s post.

     

    To solve our issue, we weren't able to provide the necessary credentials to our service account, therefore scheduled tasks had to be executed as a specific user.

    Similar had to be done with our FME Server system services. (https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Running_System_Services_Under_Different_Accounts.htm)

     

    Hope this helps.

    Community Stats

    32,154
    Posts
    122,047
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.