Problem Connecting to SQL Server using JDBC Connector

[Former Member]

Hi,

I have problem connecting to MS SQL Server using the JDBC Connector. I have 2 main questions, one is on the DQE and the other is on user mapping.

I have a created a JDBC System Landscape using the portal component com.sap.portal.systems.jdbc.

Following are the properties I have set and also I have listed where I am finding propblems.

- User Management

User MApping Type : Admin, User

- Connection Properties

Connection Timeout: 1000

Connection URL: jdbc:microsoft:sqlserver://10.7.1.5:1433;DatabaseName=SAPEP

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

(Here I do not know whihc driver to use. Do I have to use the above one or this one com.microsoft.jdbc.sqlserver.SQLServerDriver. Anyway, both of them Did not work)

- Distributed Query Engine (DQE) (What is this, and what Parameters I need to pass here)

Also, While doing the user mapping, we need to provide the username and password. What username and password is that? Is it the DB user name and Password?

Any help will be well appriciated.

Thanks and regards,

Babu

[Dan_Wroblewski]

Hi Babu,

Here's what's needed in the system (examples are from my system):

• CONNECTION PROPERTIES:

-- Connection URL: jdbc:sap:sqlserver://p031617:1433;DatabaseName=pubs

-- DRIVER CLASS NAME: com.sap.portals.jdbc.sqlserver.SQLServerDriver

-- VALIDATE CONNECTION: yes

• USER MANAGEMENT:

-- USER MAPPING TYPE: admin, user

• DQE: Put in admin user/password (DQE is for distributed queries between multiple, heterogeneous databases, but you still need to use it for simple queries)

• Create an alias

• Go to User Administration and set user mapping for the admin user

• Test connection

Each user that access the system will need user mapping.

Hope this helps.

Daniel

[Former Member]

Hi Daniel,

Thanks for your reply.

I still have the same problem. How can I find the admin username and password for DQE.

Thanks and regards,

Babu

[Dan_Wroblewski]

Hi Babu,

The DQE user/password is the same as for the database. (There is no special DQE username and password.)

When you do test connection from the System editor, do you get 2 choices -- test system via DQE and test w/out DQE? If so, do you run both? What is answer?

Daniel

[Former Member]

Hi,

I am using EP7. I want to create JDBC System for SQL Server. But DQE section is not present in the "Property Category" list box. Where should i set Database user name and password.

I checked in the Visual admin also, DQE service is running.

Reply soon.

Thanks,

Prashant