topic Re: Connecting to Azure Synapse in Product Forum

Connecting to Azure Synapse

KamilDedynski1 — Wed, 23 Nov 2022 15:00:14 GMT

Hi,

I am not able to connect to the database in Azure Synapse via Blue Prism (It's external DB, not BP DB).

An AD account is set up in Azure and I am using the correct AD credentials when I am trying to connect.

Any thoughts?

Re: Connecting to Azure Synapse

ewilson — Wed, 23 Nov 2022 16:02:12 GMT

@KamilDedynski1,

What error are you getting? How are you trying to connect to the database? Are you using the OLEDB VBO or something else?

Cheers,
Eric

Re: Connecting to Azure Synapse

KamilDedynski1 — Wed, 23 Nov 2022 16:30:30 GMT

I am using object Data - SQL Server.

I am getting an error: Login failed for user XXX

But we were also trying with a connection string in the code stage from Microsoft documentation.

I am not sure if Blue Prism supports ADD authentication.

Re: Connecting to Azure Synapse

ewilson — Wed, 23 Nov 2022 16:45:27 GMT

The Data - SQL Server VBO uses SQL Server Authentication unless the Username value is left blank. If it is left blank, then the VBO will default to Windows Authentication using the credentials of the currently logged in user.

Were you trying the connection string with the SQL Server VBO or with the OLEDB VBO?

Cheers,
Eric

Re: Connecting to Azure Synapse

KamilDedynski1 — Wed, 23 Nov 2022 19:14:54 GMT

Sorry for the confusion. I need to use another account (not a windows account) to authenticate in Azure.

I was trying to use credentials for this other account using Data - SQL Server but it didn't work out.

Is there any other way that I can connect to Azure Synapse with a different account than the Windows account?

Re: Connecting to Azure Synapse

ewilson — Wed, 23 Nov 2022 19:38:28 GMT

Hi @KamilDedynski1,

You said you tried setting the connection string value. What did you set it to?

Cheers,
Eric

Re: Connecting to Azure Synapse

KamilDedynski1 — Thu, 24 Nov 2022 09:53:17 GMT

Hi,

I was using:

Driver={ODBC Driver 18 for SQL Server};Server=ServerName.sql.azuresynapse.net,1433;Database=DBName;Uid=ROBOT_ID;Pwd=PWD;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

Re: Connecting to Azure Synapse

ewilson — Wed, 30 Nov 2022 13:34:56 GMT

Hi @KamilDedynski1,

Sorry I've been out-of-pocket. Are you still having trouble with this?

Cheers,
Eric