none
Cannot connect Microsoft sql server database to visual studio RRS feed

  • Question

  • I'm using Microsoft SQL server management studio 2017 and visual studio 2015.

    When i'm trying to connect visual studio with sql server management studio with Tools -> Connect to Database the above error occurs.

    I've tried uninstalling and reinstalling visual studio, but it doesn't work.

    Please help me to fix this.


    Saturday, November 9, 2019 6:56 AM

All replies

  • Hello,

    Most likely you have not configured the connection properly, there are many pages out there and we don't know which one you followed to create the connection.

    Here is one

    https://docs.microsoft.com/en-us/sql/ssma/mysql/connecting-to-mysql-mysqltosql?view=sql-server-ver15


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Saturday, November 9, 2019 12:11 PM
    Moderator
  • Hi Thushan,

    Thank you for posting here.

    Your text shows that you are connecting to the SQL server, but your error message shows that you are connecting to MySQL.

    The following content is based on you are connecting to MySQL.

    I tried to connect MySQL on Visual Studio 2019, and everything worked fine, so I am not sure why this error occurred.

    Maybe you can try to fix this error by referring to the following link.

    SOLVED: An unexpected error occurred in the .NET Framework Data Provider for MySQL

    FIX: An unexpected error occurred in the .NET Framework Data Provider for MySQL

    The method provided in the link modifies the registry. To prevent further damage, don't forget to back it up before modifying it.

    If you are connecting to SQL Server, please ignore the above and provide more information about the error.

    Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Hope this could be helpful.

    Best Regards,

    Timon


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.




    Monday, November 11, 2019 6:49 AM