Data - SQL Server Error

[JuliaK_]

Dear all,

I am trying to build a connection to a SQL database using the Data - SQL Server VBO. My process looks the following:

1. Set Connection
    My connection string: Provider=SQLOLEDB;Data Source=IP-address/hostname that was used to create the connection; Initial Catalog=Name of my connection; User ID=username;Password=password;
2. Open 
3. Get Collection

However, I get the following error message:
Network related or instance specific error when connecting to SQL Server. The server was not found or cannot be accessed. Check that the instance name is correct and that SQL Server allows remote connections. (provider: Named Pipes Provider, error: 40 - connection with SQL Server could not be opened)

I think my connection string is wrong but I tried several ones and none of them worked. Can anyone help me with this?

Many thanks in advance.

------------------------------
Julia K.
Student
Universität Regensburg
Europe/Amsterdam
------------------------------

[JerinJose]

Hi Julia,

please try with Data-OLEDB VBO if you are using oledb connection string

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------

[EVIPUTI]

Hi ,

The below link should help :
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-dotnet-core



------------------------------
[Vipul] [Tiwari] [Senior Process Simplification and Optimization Developer]
[Fidelity]
------------------------------