This content has been marked as final. Show 4 replies
This appears to be an issue with source user in sqlserver.
Check if you could login to sqlserver with sqlcmd tool using source user
Also check if the SQL server is set to mixed mode authentication.
Thank you Sathya for your answer.
I can connect to the database with the sqlcmd only as a Trusted source. The user with which I tryed to connect to the database is domain user, not internal SQL. Is it may be the cause of the problem?
Yes ,this can be a problem.
Please ensure below as well :
a. whether you have downloaded the drivers (sqljdbc.jar) to the $ORACLE_HOME/jlib
b. create the source user with sp_addlogin which should make use of sql server authentication.
Then re-check the issue.
Thank you Sathya, now it works.