Installing SQL 2005 on Windows 7 Issues

So, I just got a new machine at work with Windows 7 on it and I'm having issues installing SQL Server 2005 on it. I know, by default, it won't install; but, with Service Pack 3, it will. However, I cannot even get SQL Server on the machine so I can install service pack 3. All the options to install a SQL Instance on my machine are greyed out from the installation CD. I did get the client tools installed like Management Studio.

How do I get SQL Server 2005 installed on my Windows 7 machine?
infotechelgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

senadCommented:
is this the express version ?
0
kbessent1966Commented:
Why do you need 2005? You can get SQL server 2008 express for free from the microsoft website.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Check for the following:

* You are logged in using an account with Administrator privileges.
* Copy the installation DVD to your local system and try once.
* Right Click Setup.exe present under Servers folder in the installation CD / DVD and choose Run as Administrator.

Also posting the exact error encountered will help us guide you correctly..
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

infotechelgAuthor Commented:
No, it is not express. We do not have 2008 on our production server, so it is unwise to have 2008 on development then publish to a 2005 server.
0
infotechelgAuthor Commented:
rrjegan, thanks for the tips, but it still didn't work. See image.
sql.png
0
kbessent1966Commented:
Hi infotechelq

It should be possible to install. Make sure you enable these Windows features first:

Common HTTP Features
•Static Content
•Default Document
•HTTP Redirection
•Directory Browsing

Application Development
•ASP.Net
•ISAPI Extension
•ISAPI Filters

Security
•Windows Authentication

IIS6
•IIS 6 WMI
•IIS Metabase
0
infotechelgAuthor Commented:
senad, I ran SP3...now what? How do I create a SQL Instance? It doesn't appear that running SP3 did anything.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> greyed out from the installation CD

If you are installing from CD, then you should have two CD's with you..
Just copy the contents to your Local drive and try running Setup.exe present under Servers folder directly which might do the trick..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
senadCommented:
If it's grayed it means it already exists.
using config. tools you should be able to connect.
Sometimes it happens that installation fails (it happened to me twice already).
Then You should uninstall everything related to SQL server,delete all
files/folders on drive pertinent to sql server,do some registry cleaning and then start anew.
Just in case check if you perhaps created a 'named' instance during setup.
Also be careful during install for such things...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.