Solution to Database Failure after creating a new ASP. NET club stater kit site

Source: Internet
Author: User
Error description:
Database 'C: \ ASP. NET 2005 \ Club Web site starter kit1 \ app_data \ clubsite. MDF '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.
Cocould not open new database 'C: \ ASP. NET 2005 \ Club Web site starter kit1 \ app_data \ clubsite. MDF '. Create Database is aborted.
An attempt to attach an auto-named database for file c: \ ASP. NET 2005 \ Club Web site starter kit1 \ app_data \ clubsite. MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Solution:
1. Download the executable package from hereProgramSQL script. Only download clubadd.exe and then execute and decompress it.
2. Create a new database named clubsite in SQL Server Management studio. Then import the decompressed Club-Add. SQL file and execute the script.
3. Right-click the clubsite database and select detach.
4. Search for the clubsite. MDF file in the directory, copy it to the app_data directory of your club web site starter kit, and overwrite the previous one. (The location of my clubsite. MDF file is c: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data)
5. Run the program.

Related:
1. If you are using SQL Server express edition, it is more convenient to download a manager here.
2. This error occurs in the previous version of Club. VSI. download the latest version of www.asp.net.
3. Create a user, such as fanweixiao, and create a role in ASP. NET configuration named "Administrators". Then, add the fanweixiao user to this role. Use the fanweixiao account to log in and manage the page content.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.