Post reply

failed to open a connection to the database this server version is not supported

  • December 16, 2019 at 12:24 pm

    #3708117

    Hi.. Guys

     

    Thanks in adavance.

    Earlier its working fine but now this  exception is coming. I am using VS2005 and sql server 2008 r2.

    failed to open a connection to the database this server version is not supported in studio 2005

    Attachments:
    You must be logged in to view attached files.

  • December 16, 2019 at 1:36 pm

    #3708152

    You can't use SSMS 2005 to connect to SQL Server 2008 R2.  Why would you want to?  Download the most recent version from the Microsoft website.  (I suspect the same applies for Visual Studio, or BIDS as it may have been called back in the day.)

    John

  • December 16, 2019 at 8:02 pm

    #3708276

    I can confirm what John says. I actually have VS 2005 installed (as well as a few later VS versions), and attempts to connect to SQL 2008 or SQL 2014 produced exactly that error message.

    I would say that there is all reason to move to a newer version of both Visual Studio and SQL Server.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply