Which is the default port uipath is using to connect to Database while using CONNECT activity

[MariaJosephina]

Which is the default port uipath is using to connect to Database while using CONNECT activity.

If we are connecting from sql studio, we are using port 1433.
similarly from uipath which port?

[Srini84 (Srinivas Kadamati)]

@MariaJosephina

Check below for your reference

Connect to SQL Database - UiPath

Take a “Connect Activity” . Click on Configure Connection . ​[image] It pops up a connection wizard . Click on Connection Wizard . [image] Click on above options redirects you another window . Select Microsoft SQL Server option . Click on OK. [image] ​ Provide the server name ,provide the appropriate credentials (windows/sql authentication) Once authenticated this displays the list of database . Select the Database and click on “Test Connection”. ​ [image] For more details …

Hope this will help you

Thanks

[balaraman.ramiya]

hi @MariaJosephina ,

The port should be the same. all what you can check is create a odbc connection in that machine and test. This will ensure to check the connectivity from your machine to db servere works or not. If this step fails, you need to check the error and action accordingly before you try with UiPath activity.

Hope this helps.

Regards
Balram