Solved

Cannot Install SQL 2008 on Server 2008 Enterprise

Posted on 2011-03-15
5
301 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

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.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now