AD Data Adapter Authentication - Can not find login

[bradrobinson489]

I am setting up the latest versions of the studio and server CE edition, when creating the data adapter i am connecting to an SQLExpress server.

I have completed the information on the connection string, but when i try to test the connection it shows could not find matching login in the SQL log.  I am able to connect to the server remotely from another PC as well as locally from the sql management studio and i am able to connect using my own connection string from another application that i have created but connecting from jasper data adapter will not authenticate.

there is no SQL authentication allowed on the server so i am able to connect in both locations using any AD user.

 

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Badr Draifi]

Hi Bradrobinson, could you please share the logs and a screenshot of your DataAdapter connection details (please remember to mask any confidential data)? 

Fyi, here's how to get Studio logs : https://community.jaspersoft.com/wiki/finding-jaspersoft-studio-error-log

[Mehak Rajkumar]

We are eagerly anticipating your response to the comment mentioned above. Please provide the requested information so that we can assist you in addressing your question effectively.