Share via

Missing Database

Lee Taylor 31 Reputation points
2020-09-17T13:41:32.093+00:00

I can see my database in SSMS but I am unable to see it in Data Factory. Unfortunately it is the database that I need to get data into. It is in the same subscription, resource group, and on the same server with the same permissions.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,814 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2020-09-17T22:21:23.53+00:00

    Hello @LeeTaylor ,

    Thanks for ask and using this forum .

    I could suggest you to please check the following

    1. In both cases do we have the same user access . Can it be possble that while creating the linked service the user credentials passed doesn't have access to the DB you are looking for ?
    2. Assuming that #1 is not the case , can you please type in the database name and test the connection .

    25703-databasename.png

    Please let me know how it goes .

    Thanks Himanshu

    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

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.