5 Replies Latest reply on Dec 4, 2019 8:45 AM by Nico Heinze

    Error Login Failed SQL Server User

    Lucía Lozano Pinela New Member

      Hi,

       

      Last weekend several patches were applied to the Powercenter server (9.6.1 Hotfix1):

       

      https://clicktime.symantec.com/3VUNREd4qsjabdtzdCEegS36H2?u=https%3A%2F%2Fsupport.microsoft.com%2Fhelp%2F4521864

      https://clicktime.symantec.com/38m5B51giPkQx1nKkUTpRwk6H2?u=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F4520005

      https://support.microsoft.com/en-us/help/4519974/cumulative-security-update-for-internet-explorer

       

       

      Then, the following monday, we realized that some workflows had failed.

       

      The problem was that some sessions in the same workflow had failed but the rest of the sessions had run successfully. All the sessions load data into a SQL Server database. Each session uses a connection to the database, using SQL Server authentication. The relational connection is the same in each session because its value is taken from a parameter file.

       

      This is the error:

       

      Severity Timestamp Node Thread Message Code Message

      ERROR 26/11/2019 17:32:29 node01_XXXXXX MAPPING CMN_1022 Database driver error...

      CMN_1022 [

      Microsoft SQL Server Native Client 11.0: Login failed for user 'XXXXXX'.

      SQL State: 28000 Native Error: 18456

      State: 1 Severity: 14

      SQL Server Message: Login failed for user 'XXXXX'.

       

      Database driver error...

      Function Name : Connect

      Database Error: Failed to connect to database using user [XXXXXX] and connection string [XXXXXX].]

       

       

      What could be the problem?

       

      Thanks in advance.

       

      Best regards,

       

      Lucía