cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to Azure Synapse

KamilDedynski1
Level 3
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?
7 REPLIES 7

ewilson
Staff
Staff
@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
Level 3
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
Staff
Staff
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
Level 3
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
Staff
Staff
Hi @KamilDedynski1,

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

Cheers,
Eric

KamilDedynski1
Level 3
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
Staff
Staff
Hi @KamilDedynski1,

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

Cheers,
Eric​