Skip to Content

How to Create JDBC Connection

Hi,

I have read the help files but just wanted to check that I've not left anything out.

1. Created the database on SQL Server with stored procedures.

2. Created a JDBC connection on the portal.

3. User mapping set to admin, user

4. Create system alias, mapped system alias to my username and entered the username and password for the SQL database.

Connection test fails with error message :

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

Can anyone offer some advice ?

Thanks

Sue

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Sep 21, 2006 at 12:59 PM

    Hi Sue, the tests should pass...

    make sure you are seting correctly the connection properties:

    1: Connection URL: jdbc:sap:sqlserver://<SQL hostname>;DatabaseName=<database>

    ( If you are using a non standard port in SQL hostname should add ":<port>" )

    2: Driver Clase Name: com.sap.portals.jdbc.sqlserver.SQLServerDriver

    make sure the user and password are correct connecting with a SQL client.

    Regards,

    Nacho

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 21, 2006 at 01:03 PM

    Hi Sue,

    the connection test just tries to connect to the DB using the settings given. Two possibilities: You have a network problem or one of the settings is wrong.

    For the latter, two possibilities: The user mapping is wrong or one the the JDBC settings is wrong. Re-check especially the latter, see http://help.sap.com/saphelp_erp2005/helpdata/en/84/d5df3df2ad685ae10000000a11405a/frameset.htm for details (again).

    Also check the defaulttrace to maybe get deeper insight into the root cause (if you are lucky, the driver for example could not be accessed (than the problem is the (not?) installed driver or it's name), or it works and responds: "user is not authenticated", or whatever).

    Hope it helps

    Detlev

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.