Connect to MS SQL

[Former Member]

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,

1. Created a system from com.sap.portal.systems.BUDI-> SAP_BI_JDBC.

2. Fill the below parameters

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

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

3. Done the usermapping.

When I test this system, it returns an error:

<i>Retrieval of default alias successful

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

Can you please guide me on this

Thanks in advance

Srinivas Sandaka

[Former Member]

try removing the '//' from the connection string:

jdbc:sap:sqlserver:srinivas:1433;DatabaseName=Northwind

and check again