Connection test of JDBC System fails

[andrekonda]

Hi,

I create a system for my JDBC system according to this procedure:

***************************************

The steps to create the JDBC Query iView are as follows.

Login as System Administrator,

Navigate to System Administration>System Configuration>System Landscape

Create a new system,

Choose JDBC System>Assign name etc>Open Object for Editing

Under property category choose: “Connection” & assign,

Connection Timeout = 60

Connection URL = jdbc:sap:sqlserver://sqlservername:sqlTCPport;DatabaseName=SQLDBName

Driver Class Name = com.sap.portals.jdbc.sqlserver.SQLServerDriver

SAVE

Change the Property Category to: “Distributed Query Engine”

Enter the admin user\password to the oracle database.

SAVE

Change the Property Category to: “User Management”

Choose admin,user

SAVE

Now change the Display category to System Aliases

Enter a system alias for the system.

Go to user management and assign your login details to the system alias you just created.

Go back to the system in the system landscape and right click and choose connection tests

***************************************

When I choose the connection test I receive a error message. This message said to check user management and properties, but its ok. What's happen?

EP6 SP9 in WebAs 640 SR1

SQL Server 2000 SP3

Andre

[Former Member]

Hi Andre,

are you talking about an oracle db or a sqlserver? (since you mentioned both...)

Ok, I assume "oracle" was a mistake.

Here are my connection properties for connecting to my local portal database:

-Admin User & password(dqe) are filled with the correct credentials

-connection timeout: 1000

-connection factory class: JDBCFactory

-connection URL: jdbc:sap:sqlserver://127.0.0.1:1433

-Driver Class Name: com.sap.portals.jdbc.sqlserver.SQLServerDriver

-SystemName: localSQLServer

-User Mapping Type: admin, user

-Validate Connection: No

That's all and it's working.

Hope that helps, Karsten