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 · Accepted solution]

Hi,

you will need to:

1. create a JDBC system in the portal (EP). One of the parameters to that connector is the connection string you're using to connect to that system (it includes the host, port, username and password, and default DB).

2. Make sure the system works (right click on the system in the portal -> test connection).

3. Map the portal user you want to use in VC to a user you can use in that system. (whatever user you use to connect to the JDBC system).

4. Go to VC and log on to the portal. In the discovery pane you should the system you defined.

5. Choose that system and search for queries.

Hope this helped,

Lior