• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

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?
0
infotechelg
Asked:
infotechelg
  • 4
  • 3
  • 2
  • +1
1 Solution
 
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 & ArchitectCommented:
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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
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 & ArchitectCommented:
>> 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
 
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

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now