Database connection Issue. On system am able to connect the DB and able to execute query but getting an issue when i am going to connect DB using studio

[Puneet_Singh3 (Puneet Singh)]

Hi,

I am able to connect the database and also i am able to execute the query but when i am making connection using UIPath i am betting this error “Connect: Cannot open server “pearce-services.com” requested by the login. The login failed.”.
How to resolve this.

[minhduc]

Hello @Puneet_Singh3

You can connect with SQL Server, i did connect and succelful

[Puneet_Singh3 (Puneet Singh)]

Hello @minhduc

I used that only. see

[minhduc]

Hello @Puneet_Singh3

I try case of you using and it working good.

You can check again name server, port of server connect and user have correct ? If you no is configure SQL Server please contact with configure person

[Puneet_Singh3 (Puneet Singh)]

Please check this is my azure active directory connection.

[bcorrea (Bruno Correa)]

You chose sql authentication and not AD…

[Pratik_Wavhal]

Hi @Puneet_Singh3

Same issue i have faced previously

I have tried to solve this by many ways and also i have uninstall the UiPath once to check if it works but der was some issue with SQL Server Management Studio.

Once i then tried uninstalling the SQL Server Management Studio by taking backup of db’s and install it again then it starts working fine

Happy Automation

Best Regards
Er Pratik Wavhal

[Puneet_Singh3 (Puneet Singh)]

Done bro…working fine now thanks

[Pratik_Wavhal]

Hi @Puneet_Singh3

Any other solution you did or by reinstalling it started working ??

Mark as solution and like it if above solution helps you.

Happy Automation

Best Regards
Er Pratik Wavhal

[Puneet_Singh3 (Puneet Singh)]

It just issue with the connection string.

[Pratik_Wavhal]

hi @Puneet_Singh3

So may i know what did you do to solve it ??

Happy Automation

Best Regards
Er Pratik Wavhal