Unable to connect to Database using UiPath activities but able to connect to SQL DB using same credential

Help Activities
, ,
1

Hi Guys

I am unable to connect to Database and manually too but able to connect to SQL DB using same credential when I am running as a different user.

For example when I login SQL as different user and use the credential I am able to connect to the DB, but when I am opening SQL as normally and using same credentials to connect to the DB. I am getting login failed to server
similarly not able to connect to using UiPath DB activity.

2

Hi!

What version of the DB activity and what provider name are you using?
Could you give us the connection string as well?
And what is the error message?

3

Hi,

I am using connection wizard
Data provider : SQL server
Database UiPath package version : 1.9.0
SQL management Studio : 20.2
Error : Login Failed for user “user name”
Strange part is I am getting same issue in SQL server but when I login into SQL application through different user option using same credentials I am able to connect to DB.

4

@Akshay_Suryawanshi,

Most likely issue of SQL User policy. Check if any restrictions or differences for this particular user. You may try creating another user and check.

1 Like
5

I am using the same credentials for both. What to check in user policy?

6

I was asking due to this.

7

Yup. What shall I check in the user policy?