Connecting to Azure Synapse

[KamilDedynski1]

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?

[ewilson]

@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

[KamilDedynski1]

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.

[ewilson]

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

[KamilDedynski1]

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?

[ewilson]

Hi @KamilDedynski1,

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

Cheers,
Eric

[KamilDedynski1]

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;

[ewilson]

Hi @KamilDedynski1,

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

Cheers,
Eric​