How to connect to client MS sql from the local server Uipath studio

[Vrishchik (Naveenkumar Shivaraju)]

Hi All,

I need to connect the MS Sql database which is in the client server from my local dev machine(Laptop) to execute the query from the database.
Please do needful to resolve the same.

@ppr
@Yoichi
@Nithinkrishna
@ushu
@vishal.kp
@Gokul001

[AJ_Ask]

Hi @Vrishchik

You will require database activities for this

You can also watch this video for ref

1. How to connect Database in UiPath | Connect to SSMS Database | UiPath Database activities

Hope this helps

[Kartheek_Battu]

Hello @Vrishchik

1. Open Connection

   • ConnectionString: “your_connection_string”
   • ProviderName: “System.Data.SqlClient”
   • Timeout: 30 (or your preferred timeout value)

2. Execute Query

   • Connection: Use the output connection variable from the “Open Connection” activity
   • Sql: “SELECT * FROM your_table”
   • CommandType: Text (assuming it’s a simple SELECT statement)

3. Close Connection

   • Connection: Use the output connection variable from the “Open Connection” activity

Thanks & Cheers!!!