Hi
I am trying to connect to SQl server 2005 database ..Getting with login failed for user...
JDBC connection paramteres in lieu with the SQL version
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://<ip>:1433;DatabaseName=XXXX
1.I can see my driver 'sqljdbc.jar' in the com.sap.aii.af.jmsproviderlib in /ext folder .
2.I can access the database contents using studio express with the same credentials ..
3. Telnet is successful eliminating firewall/network issues .
4.SQl and windows authentication set in database
5.Document name and namespace given in sender JDBC
6 tried to establish connection picking up top 1* record from the view
Any more options to check for resolving this error ..
Please advise
Anusha