Login failed

[Former Member]

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

[Former Member · Accepted solution]

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

[former_member192295]

Hi,

First check with drivers whether have installed properly or not in XI/PI, find below link will help u for driver information.

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/winsoft.html

Meanwhile currently ur using security port 1443, check with ur network team weather have activated or not. Sometimes it is also problem.

[Former Member]

Hi,

Please check whether you have deployed, the JDBC drivers in the SAP XI server.

Regards,

Nithiyanandam

[Former Member]

HI Ava

use jdbc:microsoft:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor

The drivers which u require for JDBC adapters are

msbase.jar, mssqlserver.jar, msutil.jar

For deploying these jars, go thru this article

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/3867a582-0401...

driver for SQL is:

com.microsoft.jdbc.sqlserver.SQLServerDriver

connection is:

jdbc:microsoft:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor

Refer SAP Note 831162

Thanks

Gaurav

Edited by: Gaurav Bhargava on Oct 9, 2008 9:00 AM