I was recently upgrading my NopCommerce version 1.4 to 1.8 , I had visual studio 2008 bit 1.8 runs on Visual Studio 2010 When I installed Visual web express 2010 SqlServer 2008 also got installed on my machine while I had SqlServer 2005. I wanted to continue with it . So I uninstalled sqlserver 2008.
but I was shocked to see that I was not able to connect to sqlserver 2005. My login was changed
I uninstalled 2005 and reinstalled it Before that I took back up of my Database's files .
when I reinstalled SqlServer 2005 . I tried to attach the database but I was getting the following error.
The database '[path\MDF file] cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.
I searched and found that my databases are no longer compatible with SqlServer 2005, as when I installed VisualwebExpress 2010 sqlserver 2008 also got installed and it upgraded my databases too.
Now I have no option other then using sql server 2008.
I struggled with installation of sql server 2008 , As no clear direction found this on SQL Express home page:
Here is what you can look for.
You can manually download and install any edition of SQL Server 2008 directly from the Microsoft Download Center:
So make sure you download the SQL Server 2008 Express with Tools(It will install Managment Studio as a tool) Here are the prerequisites for installing SqlServer 2008 Express with tools Download and install Microsoft .Net Framework 3.5 SP1. Step 2 Download and install Windows Installer 4.5 [important of you have pre-Vista OS]. . Step 3 Download and install Windows PowerShell 1.0 And one more thing: If you have non-SP1 version of Visual Studio 2008, you will be stopped at the very last step before the install begins!!! So if you have VS2008 or any 2008 Express products, upgrade them to SP1 to install the Tools version to get your Management Studio Express. |
Uninstall the existing sql server and it's components
Uninstall the "SQL Server 2008 Express" installation completely from your Windows Server.
Reboot for sure.. but it's not necessary
Reboot for sure.. but it's not necessary
Install "Microsoft SQL Server 2008 Express with Tools" (SQLEXPRWT_x64_ENU.exe)
1. If you run "SQLEXPRWT_x86_ENU.exe", you'll come across a "SQL Server Installation Center" window.
2. You normally click at the "Installation" tab on the left pane, and click "New SQL Server stand-alone installation or add features to an existing installation".
3. A "SQL Server 2008 Setup" installation window appears, and have the following steps included:
- Setup Support Rules
- Installation Type
- Product Key (depending on the type of installation type you selected)
- and so on...
4. Once you get to the "Installation Type" step of the installation, instead of adding a new feature to the existing SQL Instance (that I initially setup as SQLExpress), try the install new instance, or something to that effect. There are only two options in this portion, so it won't be difficult to select.
5. Click next until you reach the "Feature Selection" step of the installation. There, select All
2. You normally click at the "Installation" tab on the left pane, and click "New SQL Server stand-alone installation or add features to an existing installation".
3. A "SQL Server 2008 Setup" installation window appears, and have the following steps included:
- Setup Support Rules
- Installation Type
- Product Key (depending on the type of installation type you selected)
- and so on...
4. Once you get to the "Installation Type" step of the installation, instead of adding a new feature to the existing SQL Instance (that I initially setup as SQLExpress), try the install new instance, or something to that effect. There are only two options in this portion, so it won't be difficult to select.
5. Click next until you reach the "Feature Selection" step of the installation. There, select All
(If you ll only select management studio not the Database engine , Your installation will be done successfully but you ll not be able to connect to server as there will be no services installed and restarted)
6. Install on
No comments:
Post a Comment