Last post Jan 29, 2016 10:54 AM by rsahapuja
Jan 28, 2016 11:33 AM|rsahapuja|LINK
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.
Jan 28, 2016 11:58 AM|PatriceSc|LINK
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.
Jan 29, 2016 06:22 AM|Zhi Lv - MSFT|LINK
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:
Jan 29, 2016 10:54 AM|rsahapuja|LINK
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.