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.
