Post reply

SSIS connection error for non administrator

  • January 18, 2018 at 11:04 pm

    #402851

    I have problem connecting to database from SSIS pkg using teradata odbc connector as a regular user but has no issues connecting the same pkg using when logged in as administrator. 

    I get the following error

    "TITLE: Microsoft Visual Studio
    ------------------------------

    Error at NPIMaster [Connection manager "Teradata Connection"]: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server. SqlState = 28000 Message = [Teradata][ODBC Teradata Driver][Teradata Database] The UserId, Password or Account is invalid.

    Error at Data Flow Task [Teradata Destination [1326]]: The AcquireConnection method call to the connection manager Teradata Connection failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
    ------------------------------
    ADDITIONAL INFORMATION:

    Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft.SqlServer.DTSPipelineWrap)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

  • January 23, 2018 at 10:48 am

    #1976959

    Tara-1044200 - Thursday, January 18, 2018 11:04 PM

    I have problem connecting to database from SSIS pkg using teradata odbc connector as a regular user but has no issues connecting the same pkg using when logged in as administrator. 

    I get the following error

    "TITLE: Microsoft Visual Studio
    ------------------------------

    Error at NPIMaster [Connection manager "Teradata Connection"]: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server. SqlState = 28000 Message = [Teradata][ODBC Teradata Driver][Teradata Database] The UserId, Password or Account is invalid.

    Error at Data Flow Task [Teradata Destination [1326]]: The AcquireConnection method call to the connection manager Teradata Connection failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
    ------------------------------
    ADDITIONAL INFORMATION:

    Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft.SqlServer.DTSPipelineWrap)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    The error is coming from the Teradata driver. Try searching Teradata's connectivity forums - there are several posts about this error:
    Connectivity

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply