Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Login failed

Hi Guys,

Im quite new here in XI version 7.0..Can anyone help me how to solve my problem..

This my connection from MSQL -> XI -> SAP (RFC)

Im using ms sql 2005. Here are the following info :

jdbc driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Connect :jdbc:sqlserver://172.16.40.20:1433;databaseName=TRAVEL:SelectMethod=cursor

Once i tried to test my config..error occured :

Im using sa login which is the administrator of the server itself..

Error during database connection to the database URL 'jdbc:sqlserver://172.16.40.20:1433;databaseName=TRAVEL:SelectMethod=cursor' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://172.16.40.20:1433;databaseName=TRAVEL:SelectMethod=cursor': com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "TRAVEL:SelectMethod=cursor" requested by the login. The

login failed.'

Please help.

Thanks in advance

aVaDuDz

replied

use this format

jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=pubs

or replace : to ; after the database name.

databaseName=TRAVEL:SelectMethod

Edited by: Anand on Oct 9, 2008 5:29 AM

Edited by: Anand on Oct 9, 2008 5:29 AM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question