-
1. Re: SQL Server connection with AD user
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
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
Thank you Nico Heinze for your kindly reply.
My sessions use a Connection Variable and I don't know if there is some option for setting the user in the session.
In relational connetion I use the right user:
Thank you so much
Federico
-
4. Re: SQL Server connection with AD user
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
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
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
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
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
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
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
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
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
Hello Harish
thank you for your help.
So let's see if I understand.
I need to uncheck "use trusted connection", like this:
But now Informatica treat the user as a MSSQL Server user or a domain user?
How can I say that this is a domain user?
thank you
Federico
-
14. Re: SQL Server connection with AD user
When 'Trusted Connection' is unchecked, SQL Server authentication will be used instead of Windows Authentication.
