SSIS and Azure Sql Database

Ratan D 1 Reputation point
2020-10-29T09:45:57.03+00:00

Hi,
I am unable to connect to Azure Sql database using SSIS(Visual Studio 2019) . I am able to connect to Azure SQl database with SSMS. Please advice.
Thanks
Ratan.
35967-ssis-error.jpg

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,606 Reputation points
    2020-10-30T06:38:13.883+00:00

    Hi @Ratan D , welcome to Microsoft Q&A forum.

    This error is mostly related to incorrect login information. While creating the connection through connecting manager, please type the appropriate database name with which you want to connect, as well as check the user name and password once again. Then click on 'Test Connection' to see if it gets succeeded.

    36271-image.png

    if this does not work out, please let us know and we can look further into it.

    0 comments No comments

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.