Connecting to Azure Synapse
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-11-22 03:00 PM
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?
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-11-22 04:02 PM
@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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-11-22 04:30 PM
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.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-11-22 04:45 PM
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
Were you trying the connection string with the SQL Server VBO or with the OLEDB VBO?
Cheers,
Eric
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-11-22 07:14 PM
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?
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?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-11-22 07:38 PM
Hi @KamilDedynski1,
You said you tried setting the connection string value. What did you set it to?
Cheers,
Eric
You said you tried setting the connection string value. What did you set it to?
Cheers,
Eric
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-11-22 09:53 AM
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;
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;
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-11-22 01:34 PM
Hi @KamilDedynski1,
Sorry I've been out-of-pocket. Are you still having trouble with this?
Cheers,
Eric
Sorry I've been out-of-pocket. Are you still having trouble with this?
Cheers,
Eric