Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: SSPI Not Initialized

  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Unhappy SSPI Not Initialized

    SSPI Not Initialized error - MSSQL 2005


    Does anyone have any clue about this intermittent error? I'm guessing it's because Kettle is trying to multi-thread the ETL and we're not using connection pools? If that's the case, is there any docs in configuring the connection pools to solve this problem?

    Thoughts?

  2. #2
    Join Date
    Feb 2008
    Posts
    4

    Default Use unique connection *seems" to work

    I'm not sure this works, but it does makes sense that it may. So far, I haven't been able to reproduce this problem with this change.
    Attached Images Attached Images  

  3. #3

    Default

    That's rigth because PDI will open new connection for each (threaded) step.
    So if you want to switch in transactionnal mode, you sould select that option :-)

    Samatar
    Samatar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.