none
Unable to connect to SQL Server 2012 from Visual Studio 2008 Server Explorer

    Question

  • Hi:

    I am having Visual Studio 2008 with Service Pack 1.

    My Database is recently migrated from SQL Server 2005 to SQL Server 2012. From the Server Explorer of Visual Studio 2008, I am not able to connect to SQL server 2012 Database.

    Please suggest a solution for this.

    Thanks in Advance!

    Best Regards,

    David.


    DAVID

    Wednesday, June 19, 2013 11:45 AM

Answers

  • Hello David,

    As the message says, connections to new SQL Server versions are not supported in VS 2008.

    You could install SSMS = SQL Server Management Studio 2012 to manage server+database, you can get the free Express Edition here: Microsoft® SQL Server® 2012 Express

    Click on download and then select "ENU\x86\SQLManagementStudio_x86_ENU.exe" or "ENU\x64\SQLManagementStudio_x64_ENU.exe" depending on your OS


    Olaf Helper

    Blog Xing

    • Marked as answer by David_7 Thursday, July 25, 2013 8:48 AM
    Wednesday, June 19, 2013 5:49 PM

All replies

  • Hello David,

    What for an error message do you get, when you try to connect to SQL Server 2012? Maybe "Not supported version"?


    Olaf Helper

    Blog Xing

    Wednesday, June 19, 2013 11:56 AM
  • Hi Olaf,

    I am getting the following error message:

    "This server version is not supported. only servers up to Microsoft SQL Server 2005 are supported."

    Thanks


    DAVID

    Wednesday, June 19, 2013 12:08 PM
  • Hi Olaf ,

    What do you suggest for this issue? 

    Thanks!


    DAVID

    Wednesday, June 19, 2013 1:42 PM
  • Hello David,

    As the message says, connections to new SQL Server versions are not supported in VS 2008.

    You could install SSMS = SQL Server Management Studio 2012 to manage server+database, you can get the free Express Edition here: Microsoft® SQL Server® 2012 Express

    Click on download and then select "ENU\x86\SQLManagementStudio_x86_ENU.exe" or "ENU\x64\SQLManagementStudio_x64_ENU.exe" depending on your OS


    Olaf Helper

    Blog Xing

    • Marked as answer by David_7 Thursday, July 25, 2013 8:48 AM
    Wednesday, June 19, 2013 5:49 PM
  • Hello Olaf,

    Thank you very much for the reply and suggestion. 

    However, our team have already installed SSMS Express edition, but still we are not able to connect. We are getting same error.

    Any other ways, please suggest.

    Thanks!


    DAVID

    Wednesday, June 19, 2013 6:22 PM
  • Which version of SSMS have they installed? It should be 2012, but even 2008 or 2008 R2 should work.

    Olaf Helper

    Blog Xing

    Thursday, June 20, 2013 12:03 PM
  • Hi Olaf,

    We have SSMS 2012 Client edition installed on the machines.

    From SSMS Window, we are able to connect. But, the problem is connectivity from Visual Studio 2008 Server Explorer.

    We are using Server Explorer for Drag and Drop Stored Procedures into .dbml file - i.e. for LINQ.

    Please find the Screenshot below for your reference:-

    Error_Message


    DAVID

    Thursday, June 20, 2013 1:14 PM
  • Hello,

    Please refer to the following thread which about similar issue. You can try the solution as Sayed post.
    http://forums.asp.net/t/1721552.aspx/1?Working+with+Denali+SQLEXPRESS+in+VS+11+Database+issue

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Thursday, June 27, 2013 9:03 AM
    Moderator
  • Hi David, I am having exactly the same issue you mention. I can't connect from VS 2008 via Server Explorer to MS SQL Server Express 2012. How did you solve your issue?

    Thanks

    EdilG


    Saturday, November 09, 2013 11:53 PM
  • As I wrote, use SSMS = SQL Server Management Studio instead.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Sunday, November 10, 2013 7:39 AM
  • Exact same issue here. What was the solution ?  SSMS is not helping at all with that problem.  We are using LINQ TO SQL so we need to import tables in the .dbml file using Server explorer.

    We get exact same problem as David.

    Tuesday, June 03, 2014 3:05 PM