SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
569 questions
TITLE: Connection Manager. The specified provider is not supported. Please choose different provider in connection manager. This error occurs when i try to configure ole db manager.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 6%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pranav
0
Reputation points
TITLE: Connection Manager
The connection string is not valid.
BUTTONS:
OK
this error comes up when i try to keep the provider as native ole db\microsoft ole db provider for sql server
SQL Server Migration Assistant
{count} votes
-
Olaf Helper 47,516 Reputation points2024-06-04T18:01:05.2733333+00:00 The connection string is not valid.
With that less on information no one can guess.
But by the error message I guess you entered something; again, I can't guess what.
-
Erland Sommarskog 122K Reputation points MVP Volunteer Moderator2024-06-04T20:54:08.55+00:00 Does this happen with SQL Server Migration Assistant (which you have tagged the question with)? Or something else?
In any case, with the information given, the only advice I can give is that you enter a correct connection string.
If you tell more in detail what you are doing, and share the connection string you are trying to use, we may be able to help more.
Sign in to comment
Sign in to answer