March 12, 2011

Install sqlserver 2008 on Windows 7


To Install sqlServer2008 on Windows 7 you need SqlServer2008 Service Pack1 to resolve compatibility issues
1.) Download it from the below link
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 pop up of 
 incompatibly, You have to click on Run Programs on that pop up
2. If you run "SQLEXPRWT_x86_ENU.exe", you'll come across a "SQL Server Installation Center" window.
3. 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".
4. 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...
5. 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.
6.Once you get to the "add service account type" Choose the NTAuthority User from the  drop down list options
7. Once you get to the "Authentication Type" you can choose windows authentication  and click on Add Current user button then Click on Next 
8. 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)
9. Install on 

No comments:

Post a Comment