Error when attempting to use new SQL Server Service account within Azure Data Factory Linked Service

Kieran Wood 101 Reputation points
2021-11-09T11:47:41.797+00:00

Error code22300
Troubleshooting guide
DetailsCannot connect to SQL Database: 'my-srv.database.windows.net', Database: 'my-db', User: 'svc_DEV'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Login failed for user 'svc_DEV'., SqlErrorNumber=18456,Class=14,State=1, Activity ID: 54d1ca81-a393-4433-ad31-4c829e142dc6.
Any help would be greatly appreciated.
Kind Regards,
Kieran

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,603 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-11-09T21:31:59.383+00:00

    Hello @Kieran Wood ,
    Thanks for the ask and using Microsoft Q&A platform .
    I am not sure as what you have tried . At this time you need to update the service account ( new one ) in the linked service . I am sharing the screenshot below .

    147829-image.png

    147981-image.png

    Please do let me know how it goes .
    Thanks
    Himanshu

    -------------------------------------------------------------------------------------------------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments
  2. Manish Kumar 1 Reputation point
    2022-03-01T16:38:50.677+00:00

    I faced same issue. Please refer
    https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure#connections-from-inside-azure

    When an application from Azure tries to connect to the server, the firewall checks that Azure connections are allowed by verifying this firewall rule exists. This can be turned on directly from the Azure portal blade by switching the Allow Azure Services and resources to access this server to ON in the Firewalls and virtual networks settings

    0 comments