Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2008 R2 Installation - Missing Instance Features


SQL 2008 R2 Installation - Missing Instance Features

Author
Message
nmadrigal
nmadrigal
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 329
Hey everyone. I'm trying to install a Database Server using SQL Server 2008 R2 Enterprise edition on Windows Server 2008 SP1 32-bit. No errors during installation, but when I get to the Feature Selection screen my only option under Instance Features is Analysis Services. The configuration check shows no errors, and skimming through the setup log files doesn't indicate any issues. I've verified the setup files by running on my 32-bit laptop, which worked correctly. This is a brand new server OS install, so there are no previous installs.
calvo
calvo
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1380 Visits: 3965
Only thing that comes to mind is make sure you have the correct software (.iso).
Where did you get it from?

______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
nmadrigal
nmadrigal
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 329
Thank you for the reply! We have a MSDN subscription, and so I got it off their website. I was able to use this same install for a 64 bit installation without any issue, and also on my laptop (32-bit)
Fabrizio Faleni
Fabrizio Faleni
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 456
Are you sure that setup finished normally? Didi you see the final window confirming that setup was successful?

I have had the SQL2008R2 Setup.exe crashing a few times: it would be possible that you do not get any error in the setup log because the application crashed and just did not complete the setup.

In this case you should have some trace of this in the event log.

If this is the case, you can try to access the setup "Tools" page and run the Repair. More info and links on this blog

MCITP Database administrator 2008
MCTS SQL Server 2008 Implementation and maintenance
MCTS Sharepoint configuration
MCP Designing Deploying and Managing a Network Solution for the Small and Medium-sized Business
ITIL V3 Foundation

nmadrigal
nmadrigal
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 329
Thanks for the reply! I didn't finish the setup completely as I am not able to select to install a database instance. My only option is to install Analysis Services, which I don't want to install. It is very bizarre, as I can't find anyone thus far with a similar issue.
calvo
calvo
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1380 Visits: 3965
nmadrigal (9/21/2011)
Thank you for the reply! We have a MSDN subscription, and so I got it off their website. I was able to use this same install for a 64 bit installation without any issue, and also on my laptop (32-bit)

Are you saying you have already used the same software to install a 64bit version instance on something and you also used the same software to install a 32bit instance on your laptop?

______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
nmadrigal
nmadrigal
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 329
Yes. I verified from the MSDN website that this ISO has the installs for both 64 and 32 bit versions, as that was my first thought.
calvo
calvo
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1380 Visits: 3965
Alright, that is sketchy. I don't know what the problem is but if I had to guess, you might be failing some pre-reqs. If you've used this same iso to install on a 64bit server and a 32bit server, that leads me to believe the problem is the server on which you are trying to install.

*just thinking*
Even if there were an database instance already on the server (through visual studio or some other application), it should still give you the option to install a second instance.

______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
nmadrigal
nmadrigal
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 329
Agreed. We just installed SP2 for the operating system, and I ran the install again. Now I see Analysis Services and Reporting Services, but nothing to install a database instance. It must be something on the server or the install files got messed up somehow.
andrew.j.borelL
andrew.j.borelL
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 8
This has happened to me when I had an express install with tools on the machine already. I think you might want to start by upgrading that install via the sql server 2008 installation center(64-bit), from the maintenance->edition upgrade screen.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search