Connect to MS SQL

[#1]

Hi,

Can anybody tell me the detailed procedure to connect MS SQL server from VC.

Which system I have to create in EP and what are parameters to that system.

Thanks in Advance.

Srinivas Sandaka

[Former Member]

Hi,

I got the connection with EP6 SP4 through VC.

<b>Conntection URL:</b> jdbc:sap:sqlserver://srinivas:1433;DatabaseName=Northwind

<b>Driver Class Name:</b> com.sap.portals.jdbc.sqlserver.SQLServerDriver

But in SP9 it is giving error.

Thanks

Srinivas S

[Former Member]

Hi Srinivas,

Try specifying the IP address instead of "srinivas" in the connection URL. As well check ur database name(for case sensitivity)

<b>Connection URL</b> = jdbc:sap:sqlserver://198.XXX.XX.XX:1433;DatabaseName =Northwind

<b>Driver Class Name</b> = com.sap.portals.jdbc.sqlserver.SQLServerDriver

<b>User Mapping Type</b> = user

• Create a system alias for this newly created JDBC system

• specify the database userid and password in personalization properties of the portal

• see that the server you are trying to login is SQL Authenticated or Windows Authenticated.

Its should be <b>SQL Authenticated</b> with the userid and password.

• Check whether you can access the tables from SQL Utitlity Manager with the same userid and password you have specified.

Hope this helps,

Thanks,

Praveen

PS. Dont forget to award points if found useful or solved.