Unable connect with the "SQL Server Management Studio" using Uipath

[Jayavignesh_G]

Hi all,

I was not able connect with the “SQL Server Management Studio”. I am not sure what was the issue was ?

FYI : I have given “Test Connection” it is successful and My SQL server is connected while trying the activity.

Can any one try to resolve it ASAP ?

@Palaniyappan
@NIVED_NAMBIAR

Thanks in advance,
Jayavignesh G

[postwick (Paul Ostwick)]

You don’t use SQL Server Management Studio to connect from an automation. You just use the database activities.

From the error it looks like you’ve selected the wrong database provider when configuring the connection. SQL Server and MySQL are two different things.

[Jayavignesh_G]

Hi Postwick,
FYI : I have given “Test Connection” it is successful and My(Mine) “SQL server Management” is connected while trying the activity.

[postwick (Paul Ostwick)]

Show us your config. And you don’t have to use both activities. The Execute Non Query activity can just be on its own.

[mahmoud.zaky]

if you use ODBC connector kindly show us the connection configuration also show us the Connection String
Note:
Do not forget to disconnect the connection after finishing

[Jayavignesh_G]

Hi,

Uipath:

[postwick (Paul Ostwick)]

Get rid of the Connect activity, configure the connection in the Execute Non Query activity, and then try it.