Control Panel Forum Hosting Help ASP.NET 3.5 & SQL 2008 Web Hosting Resources

Total members: 133426
Average new registrations per day (in last 7 days): 122

New Registration: Open

Register Now

Want to become a DBA ? SQL Server 2008 training courses - by AspSpider team

Home » Resources » Cannot be upgraded because its non-release version (600) is ...

ASP.NET	ADO.NET	Web Services	Remoting	Visual Studio 2005
Error Bank	Interview Questions	Tips & Tricks	XML	HTML
Jscript/Javascript	IIS	Windows		General

Submit Resource or code snippet ... and get surprise gifts ASP.NET web hosting

Win Digital camera, ASP.NET Books, Free softwares!!

Cannot be upgraded because its non-release version (600) is not supported by this version of SQL Ser

12 Dec, 2005

Author: †óñÿ !

/manju

Welcome to my homepage

Summary
Another error while trying to deploy Club Starter Kit: "Cannot be upgraded because its non-release version (600) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database."

.NET Classes used :

Finally, I decided to learn from experts, instead of writing my own samples to learn. So, I downloaded the Club Web Site Starter Kit (http://www.asp.net/default.aspx?tabindex=5&tabid=41#Club) and deployed in my home computer. Everything went though fine, except that when I launched the web site, an error message was thrown:

"cannot be upgraded because its non-release version (600) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database."

It was funny! I know that there are thousands of people using Club Starter Kits. Finally, I used the one-click deploy feature of AspSpider.NET and deployed the Club Starter Kit in my AspSpider account. Then I detached and downloaded the club database to my local machine. That worked great!

What does that mean? Microsoft is shipping the Club Starter kit with non compatible version of the database? The database that is shipped with Club kit is compatible with a beta release of SQL Server 2005 Express.

I searched for the error message and found some tips here - http://bloggingabout.net/blogs/erwyn/archive/2005/11/7.aspx.

Tips from Ervin worked very cool. I just had to do the below steps to successfully deploy the club web site starter kit:

1. Create a new database called "Club" in my local SQL Server 2005 Express, using SQL Server Management Studio .

2. Download the scripts to create the club database schema and other objects(http://www.microsoft.com/downloads/details.aspx?FamilyId=0DD83A11-6980-4951-A192-DA6EACC6A19E&displaylang=en.

3. Open the downloaded scripts in SQL Server Management Studio and run it against the club database.

4. Detach the database from SQL Server and move the clubsite.mdf to the App_Data folder of the ASP.NET web application.

5. Ensure all connection strings are correct and point to the correct file name (.mdf).

Feedbacks about this page from members:

- No Feedbacks yet !! -

Submit Feedback View All Feedbacks