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

Question

User-170024082 posted

Hi,

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.

Thanks,

Rinku

Answer 1

User753101303 posted

Hi,

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.

Answer 2

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:

http://forums.asp.net/t/1334327.aspx

http://stackoverflow.com/questions/175881/sql-server-express-2008-install-side-by-side-w-sql-2005-express-fails

Best regards,
Dillion

Answer 3

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.

Thanks,

Rinku