JDBC sender -Login Failed

[former_member335553]

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

[naveen_chichili]

Hi Anusha,

Please check if you are able to login to your DB from http://<host>:<port>/ftpjdbc by providing your details.

Also please go through the note #1085539 for more details.

Thanks,

Naveen.

[former_member335553]

Hi

Driver Class Could not be found.com.microsoft.sqlserver.jdbc.SQLServerDriver

I get Class not found exception ....How do I check if the drivers have been properly installed ?

Could you please let me know

[Former Member]

Hi Anusha

It looks like the drivers have not been installed. Ask your basis team to check and deploy the correct driver.

Also, according to this wiki, it seems that the connection string is not correct.

http://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup

It should be jdbc:sqlserver://<host_name>:<port>;database=<db_name> (database instead of DatabaseName)

Regards,

Giuseppe

[naveen_chichili]

Hi Anusha,

Check with your basis team if JDBC drivers are installed correctly.Also you can refer to the document:[LINK|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d88f?quicklink=index&overridelayout=true]

Regards,

Naveen

[baskar_gopalakrishnan2]

I guess problem with windows authentication mode... Just use SQL authentication. Please check this..

[former_member208856]

first ping your JDBC system from SAP PI Server.

IF you are able to ping that system.

Now try to import JDBC matadata in SAP PI System, take help from below blog for importing matadata.

/people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-import-sql-tables-metadata