Connect to DB using Service Account

Help Activities
, ,
1

How to connect to Database using service account instead of SQL credentials/Windows credentials?

I have tried using SQL credentials and entered service user mail ID and password in credentials section. But unable to connect.

2

Hi @prathamesh.patil2

What error that you are getting?

Make sure the service account has the required permissions on the database server. This typically involves granting appropriate roles or permissions within the database itself.

Assign Permissions to User in SQL Server (tutorialsteacher.com)

3

Hi @prathamesh.patil2,

Welcome to the UiPath Community :tada:

Your connection string should be like this.

Data Source=your data source;Initial Catalog=DB Name;Integrated Security=true

Integrated Security=true this part will work as windows credentials. No need to explicitly mention credentials.

Thanks,
Ashok :slight_smile: