Sserver version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later RRS feed

  • Question

  • User-170024082 posted


    I have developed .net Project using VS 2005 and SQL 2005.

    Recently we migrated the DB to SQL 2008. After that onwards this issue started.

    I have installed VS service Pack 1  from here https://www.microsoft.com/en-us/download/details.aspx?id=804  . Now I am able to access the data. but when I am trying to re-configure or connect with new table I am getting this error.  “This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later.”

    For your reference I am sharing the Connection string I have used  <add name="RMS.Properties.Settings.RMSConnectionString" connectionString="Data Source=DBDEV\RMS;Initial Catalog=RIMS01;Integrated Security=True" providerName="System.Data.SqlClient" />

    Please help me to fix this issue. Let me now if you need further information on this regards.



    Thursday, January 28, 2016 11:33 AM

All replies

  • User753101303 posted


    I would check SELECT @@Version to make sure which SQL Server version is used (I suspect it might be "SQL Server 2008 R2" while VS 2005 SP1 seems to support "SQL Server 2008" only).

    I would consider to move away from VS 2005 or for now you'll likely have to use SQL Server Management Studio instead depending on what exactly you are doing.

    Thursday, January 28, 2016 11:58 AM
  • User-271186128 posted

    Hi Rinku,

    As for this issue, before install the Sql Server 2008 express on the machine with SQL 2005 Express already be installed, please try to uninstall 2005 version's components manually and then install 2008 version.

    Here are some relevant threads with the same problem, you could refer to them:



    Best regards,

    Friday, January 29, 2016 6:22 AM
  • User-170024082 posted

    Hi Zhi,

    Thank you for your suggestion.

    actually SQL 2005 management studio i have already uninstall. now i am using SQL Management studio 2008. and SQL management studio 2012 is also install in my system.

    Regarding SQl Version please refer this  " Microsoft SQL Server 2012 - 11.0.5058.0 (X64)   May 14 2014 18:34:29   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) "

    Actually our Database is in SQL 2012 but we made compatibility as SQL 2008 . so i believe it should work. 

    Please suggest me how can i fix this.



    Friday, January 29, 2016 10:54 AM