Azure SQL Database
An Azure relational database service.
5,278 questions
A community member has associated this post with a similar question:
Creating new linked services returns SqlFailedToConnect
Only moderators can edit this content.
Creating new linked services returns SqlFailedToConnect
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kristina Payan
0
Reputation points
I'd like to start by first stating that this is a continuation of my efforts to connect an Azure SQL DB to Data Factory via the Linked services.
Creating new linked services returns InvalidCredentialReference
My new error is below:
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'log1.database.windows.net', Database: 'DB2', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Database 'DB2' on server 'log1.database.windows.net' is not currently available. Please retry the connection later.
I've tried: Azure SQL Server -> Access control (IAM) -> Role assignments -> added role assignment -> LOGDF (which is the data factory I created) I've given the following access.. roles: Owner, Contributor, SQL DB Contributor
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT 14,186 Reputation points Microsoft Employee2024-05-22T03:22:58.3766667+00:00