Solved

Cannot Install SQL 2008 on Server 2008 Enterprise

Posted on 2011-03-15
5
305 Views
Last Modified: 2012-05-11
Hello Experts,
 I desparately need some help and was hoping I could find it here. I have a Dell PowerEdge 2950 on which I have installed Server 2008 Enterprise x64. I am trying to install SQL 2008 but I get an error when running setup.exe from the disk that states that .Net 3.5 is not installed. The exact error message is as follows:

Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 requires .NET 3.5 Framework to be installed.

Well, .NET Framework 3.5 is installed. So I did some research and found many people with this peoblem but no clear solution. One suggestion was that Windows Installer 4.5 needed to be downloaded and installed. So I went to the download mirrior, found the files with which Microsoft said were compatible with my architecture, but when I ran them I got and error message stating that that version of the installer was not compatible with my architecture. So I tried every other file on the page, thinking that maybe MS had gotten their file names mixed up or something. Same error with every file.

I am at a loss. I have to get this Server up and it will be running a specialized application that requires SQL. I don't want to revert back to Server 2003......Please help.....
0
Comment
Question by:BoxunloX
  • 3
5 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35137366
Have you tried to install .NET from your installation cd?
<installation drive>\x64\redist\DotNetFrameworks\dotNetFX35\x64\netfx35_x64.exe
Is your system Windows Server 2008 R2 maybe?
0
 
LVL 1

Author Comment

by:BoxunloX
ID: 35335539
What I ended up doing was running a script I got from Microsoft that opened certain ports in the firewall that had been locked down by the guys that built the original image. I'll post it here when I get back to work tomorrow.
0
 
LVL 6

Expert Comment

by:Osmoze
ID: 35698780
Hello,

Use a Valide media for installing , not the downloaded from MS web site , if you can get the original DVD use it ,also dont install it remotly ( sharing your dvd-rom) with the server , connect it directly .

i ve been in the same situation , and that's i ve done to get it working .
0
 
LVL 1

Accepted Solution

by:
BoxunloX earned 0 total points
ID: 35731965
This is the script I used that allowed the install to complete:
@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer" 
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection" 
@echo Enabling conventional SQL Server Service Broker port 4022  
netsh firewall set portopening TCP 4022 "SQL Service Broker" 
@echo Enabling Transact-SQL Debugger/RPC port 135 
netsh firewall set portopening TCP 135 "SQL Debugger/RPC" 
@echo =========  Analysis Services Ports  ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services" 
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser" 
@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80 
netsh firewall set portopening TCP 80 "HTTP" 
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL" 
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser" 
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

Open in new window

0
 
LVL 1

Author Closing Comment

by:BoxunloX
ID: 35763173
The issue ended up being with the locked down version of Server 2008 Enterprise that I was using. I had to run a script I found on technet.microsoft.com and after doing so the install worked great.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question