1 2 Previous Next 16 Replies Latest reply on Mar 5, 2020 9:19 AM by Nico Heinze

    SQL Server connection with AD user

    Federico Fanalista New Member

      Hello everybody

      I would ask you how I can use a SQL Server connection with AD User to access business data.

      My problem is this:

      I have two AD user:

      1. svc_infpowcenord: AD user which runs the Informatica service and used to connect other services (PC Repository Services) to SQL Server Database
      2. svc_infpowcenbusprd: AD user used in Relational Connection for connect into business database for target tables

      DBA gave grants to access business DB (where my ETL writes data) only to svc_infpowcenbusprd.

      At the first lunch I received this error:

       

      Database driver error...

      CMN_1022 [

      Windows authentication is used to access the Microsoft SQL Server database

      [Informatica][ODBC SQL Server Wire Protocol driver]Socket closed.

      SQLSTATE: 08S01

      [Informatica][ODBC SQL Server Wire Protocol driver][SQL Server]Login failed for user 'MYAD\svc_infpowcenprd'.

      SQLSTATE: 28000

      Database driver error...

      Function Name : Connect

      Database driver error...

      Function Name : Connect

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

       

      I was surprise to saw that svc_infpowcenprd wanted try to connect to the DB.

      I had assumed that this user should never connect to business data.

      Later I tried to switch grants between 2 users and my flow worked.

      But I need to avoid to give grants to this user (becuse of police company).

      So could you help me to allow only svc_infpowcenbusprd to access to business data?

      Thank you so much

      Federico

        1 2 Previous Next