Share via

The conection failed because of an error in initializing provider.The SQLCLI11 provider is not registered on the local machine

05517918 0 Reputation points
2024-08-03T12:40:02.2+00:00

I am not able to see any databases or names in connection manager for SQL server destination. I have given the right server but no databases are being shown and a native server client error is coming.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,567 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ahad Karimi Moridani 80 Reputation points
    2024-08-03T17:54:14.3266667+00:00

    Looks like you're missing the SQLCLI11 provider. Try installing or re-registering the SQL Server Native Client, and you should be good to go.

    0 comments
  2. ZoeHui-MSFT 36,116 Reputation points
    2024-08-05T06:31:15.6033333+00:00

    Hi @05517918,

    You may install SQL Server Native Client for a try.

    If this does not work, please repair VS.

    User's image

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 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.