65017

SQL Server version 612 , 655?

Question:

I have SQL Server 2008 and VS2008 installed on my computer and I am trying to run a web application I've created on a computer which has SQL Server 2008 and VS2008 and VS2010 beta 2 with its SQL Server Express.

I am getting an error with the database version that is "...aspnetdb.mdf" cannot be opened because it is version 655. This server supports version 612 and earlier...."

Configuring the database in Visual Studio ->Tools -> Options -> Design-Time Validation Database is not working since I don't have the SQL Server version comes with VS 2010.

EDITED : I also edited aspnetdb and inserted a few more tables so I need the same aspnetdb

Is there any solution to convert this db ?

Also, after fixing this, I am looking forward to upload it on my hosting which has SQL Server 2005 DB and configure it in PLESK.

Answer1:

The SQL Server databases have a version specific format. Each SQL Server runtime version (SQL 2008 SP1, SQL 2008 RTM, SQL 2005 SP2, SQL 2005 SP1, SQL 2005 RTM etc) knows how to upgrade to its own verison. Unfortunately, once upgraded the database cannot be downgraded. So if your MDF was upgraded to version 655, it cannot be downgraded to any prior version. If you know you're going to deploy on SQL Server 2005, you <strong>must</strong> develop on SQL Server 2005 too. Not only that, but the actual build number of your development has to match the build number of the deployment (or at least be lower than that): the SP level and CU level must match.

You can a attach the 2008 version MDF you created to a SQL Server 2008, script out the database content, then import the script into a SQL Server 2005 database of the proper version.

Answer2:

I had this problem and when I changed my_computer_name\SQLEXPRESS with . to connect to server and it works and I could attach MDF file

Answer3:

may be you have both services run. (Mssql2008 and mssqlexpress) Maybe you have runing the mssqlespress running, that's the error that you have. Try to stop the mssqlserver express service and run mssql2008 services, and attach again your databases. I try this and works for me

Recommend

  • conditional labeling in rows
  • Generate one file for a list of parsed files using source_gen in dart
  • NumPy won't upgrade from 1.5.1 to 1.6.2 on OS X 10.7
  • I need to call another sql file within an sql file using sql plus
  • I'm not understanding these uses of std::result_of and decltype
  • Open second Python console
  • Word to html conversion using php
  • Linq query with a Conditional WHERE Clause
  • Plotting a continuous stream of data with MatPlotLib
  • Scala and SBT install on Debian with Java 8
  • how to make all possible power set(or subset) from arrayList objects?
  • Remove Textmate Git Bundle
  • Setup SignalR and Service Bus inside a Azure Service Fabric service
  • cordova edit-config not updating AndroidManifest.xml
  • Call a specific instance of a service in Azure Service Fabric
  • How to check if the current repository is the top level git repo
  • Identifying dates in strings using NLTK
  • Thick underline when hover AND when active
  • Bazel failed to include a external static library .a
  • How to create OLE Automation to be used with ClearExplorer
  • How to find angle formed by the blades of a wind turbine with respect to a horizontal imaginary axis
  • 2d barcode reader Java ME sdk
  • playing mp3 from nsbundle
  • .Net core Hosted Services guaranteed to complete
  • opencv deskewing a contour
  • How to define a custom accuracy in Keras to ignore samples with a particular gold label?
  • How to use AJAX to upload large CSV file? [closed]
  • How convert html to BBcode in C#
  • Google Spreadsheet Script to Blink a range of Cells
  • How do I add a mouse over tooltip to an Image using .DrawImage()
  • Google App Engine backend servlet not responding
  • Unity3d lost directional light shadows after generate assetBundle (.unity3d file)
  • Make checkout phone field optional for specific countries in WooCommerce
  • Excel VBA : conditional formatting of sheet1 cells from sheet2 values in excel 2007
  • Jersey serializes character value to ASCII equivalent numeric string
  • PHP Permalinks.. how to change?
  • media foundation H264 decoder not working properly
  • Running R's aov() mixed effects model from Python using rpy2
  • How to mutate multiple variables without repeating codes?
  • Access to a Matlab gui from the web