-
1. Re: SQL Server connection with AD user
Nico Heinze Feb 15, 2020 1:32 PM (in response to Federico Fanalista)Could you please double-check that the business user and not the pwc user is named in the session?
To me this looks as if the relational connection names the wrong user.
Regards,
Nico
-
2. Re: SQL Server connection with AD user
Sachin Kumar Feb 17, 2020 1:57 AM (in response to Federico Fanalista)Please give grants to user svc_infpowcenbusprd to access database and ensure to use the same user in relational connection in workflow manager.
-
3. Re: SQL Server connection with AD user
Federico Fanalista Feb 17, 2020 7:16 AM (in response to Nico Heinze) -
4. Re: SQL Server connection with AD user
Federico Fanalista Feb 17, 2020 7:21 AM (in response to Sachin Kumar)Thank you Sachin Kumar for your kindly reply.
svc_infpowcenbusprd have already grants to access to database.
As you can see above the user is the same.
thanks
Federico
-
5. Re: SQL Server connection with AD user
Nico Heinze Feb 17, 2020 8:06 AM (in response to Federico Fanalista)Then please double-check that the correct connection variable has been named in the parameter file which you have to use for this session.
Regards,
Nico
-
6. Re: SQL Server connection with AD user
Federico Fanalista Feb 17, 2020 8:13 AM (in response to Nico Heinze)I'm pretty sure is correct becouse I have only two connections: one for source (oracle) and one for target (sql server).
Regards
Federico
-
7. Re: SQL Server connection with AD user
Nico Heinze Feb 17, 2020 8:30 AM (in response to Federico Fanalista)In theory, the Oracle source database may have a database link (e.g. via Golden Gate) pointing to the repository database in SQL Server.
So if the source connection names an object which is linked to the repository DB in SQL Server, then this may be the only reason I can currently see why the wrong database is sourced.
If that's not the case, please open a service request with Informatica Global Customer Support to have this investigated. I don't see any other potential issues by now.
You did check in the session log that the correct connections were used, did you?
No offense intended, I've made such mistakes myself in the past.
Regards,
Nico
-
8. Re: SQL Server connection with AD user
Federico Fanalista Feb 18, 2020 3:54 AM (in response to Nico Heinze)Hello Nico
thanks again.
I tried again: DBA disabled svc_infpowcenprd from business db and enabled svc_infpowcenbusprd.
This is the log:
ERROR 18/02/2020 12:13:49 DisNodePrd01 PRE-SESS CMN_1022 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'. Reason: The account is disabled.
SQLSTATE: S1000
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].]
Really I don't understand why svc_infpowcenprd try to connect. This is only a user for informatica domain and services.
And the other error: svc_infpowcenbusprd have all permission to access to the sql server machine and this particular database.
I'm desperate
thanks
federico
-
9. Re: SQL Server connection with AD user
Nico Heinze Feb 18, 2020 7:42 AM (in response to Federico Fanalista)Unfortunately that's not my primary area of expertise. I do know that using AD users for DB access is possible, we're doing that all the time at my current customer site. But the setup is a little tricky, in particular when it comes to access management.
Please open a service request at Informatica Global Customer Support (GCS), they can tell you exactly what needs to be set up how and what gotchas are waiting for you (such as in your case). I simply don't know all these details.
All the best and please let us know how you proceed,
Nico
-
10. Re: SQL Server connection with AD user
Federico Fanalista Feb 18, 2020 8:49 AM (in response to Nico Heinze)hello again Nico
I'm following your advise and I'm trying to open a GCS but I can't see the eSupport button on my page...
I asked for help.
thank you
Federico
-
11. Re: SQL Server connection with AD user
Nico Heinze Feb 18, 2020 10:37 AM (in response to Federico Fanalista)If you don't see that button. then you probably are not listed as a Read/Write Contact for your organisation's GCS "project". Please ask your INFA administrator to be enrolled as such, or that this person opens a case and names you as the primary person to contact (then you don't have to be a Read/Write Contact).
Otherwise just give GCS a phone call, they can tell you how to proceed.
Good luck and regards,
Nico
-
12. Re: SQL Server connection with AD user
Harish Kumar Dola Feb 18, 2020 12:38 PM (in response to Federico Fanalista)1 of 1 people found this helpfulOn Windows, trusted connection uses service user account as designed. From documentation :
On a trusted connection, we can't use any other account.
Thanks,
Harish
-
13. Re: SQL Server connection with AD user
Federico Fanalista Feb 19, 2020 3:53 AM (in response to Harish Kumar Dola) -
14. Re: SQL Server connection with AD user
Shivanga Srinivas Bandaru Mar 4, 2020 5:38 PM (in response to Federico Fanalista)When 'Trusted Connection' is unchecked, SQL Server authentication will be used instead of Windows Authentication.