Share via

Cannot connect OnPrem SQLServer to Azure

Arpit Sharma 0 Reputation points
2023-11-02T23:20:09.64+00:00

This is the error I get:
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'localhost', Database: 'AdventureWorks2022', User: 'arpit'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

Login failed for user 'arpit'., SqlErrorNumber=18456,Class=14,State=1,

User's image

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,449 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,633 questions
SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Arpit Sharma 0 Reputation points
    2023-11-03T03:28:00.8833333+00:00
    0 comments
  2. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2023-11-03T03:57:34.11+00:00

    As the OP cannot accept his own answer, reposting the answer to close this thread :

    It seems Windows AUth is only enabled for the server.

    So to allow SQL auth, enable SQL and windows auth as stated in the below thread :

    https://www.getfishtank.com/blog/login-failed-error-18456#:~:text=(Microsoft%20SQL%20Server%2C%20Error%2018456)%22%20is%20the%20most,configured%20for%20Windows%20Authentication%20mode.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.