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,