Installation Notes: SQL Server 2005 on Windows Vista with VS2008

Author: May

(4 votes, average: 4.50 out of 5)

Loading ...

20 Feb

This was a humongous pain for me and took quite a lot of my time so just noting down a few points for self reference. Previously, I have Visual Studio 2005 and SQL Server 2005 installed on my Vista machine and they worked just fine. Now we are upgrading to VS2008, I uninstalled everything related to VS2005 then reinstall SQL Server 2005 and things got screwed up. Check out the failure list that I got – pretty much everything failed.

The worst thing about this installation is that, it takes ages to install till the end, then shows up the error message box.

Program Versions:

# SQL Server 2005 – Developer Edition
# Windows Vista Ultimate
# Visual Studio Team Suite 2008

Make sure you cross check Hardware and Software Requirements for Installing SQL Server 2005 before installation.

The first error/warning I tried to fixed was about IIS requirement. I’m sure I have IIS7 enabled on my Vista and also enabled IIS6 compatiblity mode but that is not enough and have to enable some more features.

System Configuration Check

System Configuration Check: IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove programs in Control Panel or enable the IIS server through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

I think it is to do with Installing SQL Server 2005 Reporting Service on Vista, untill or unless you enable all those features the Reporting services cannot be installed.

Solution:
The main features to turn on are as mentioned here but I turned on almost everything just to make sure.

More info links:
# How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer
# Installation of SQL Server 2005 in Windows Vista – warning message on IIS feature requirement during System Configuration Check
# Tip for Installing SQL Server 2005 Reporting Service on Vista

Ok, this one is the weirdest error and solution I got. Don’t even ask why in the world do I need to install Office 2003 Web Component add-in while I have Office 2007 installed on my machine. I have no clue, but that’s the only solution I found which works for me. It solves the “OWC11 Setup failed error and the following error message.

ERROR 1706 Setup cannot find the required files. Check your connection to the network, or CD ROM! For other potential solutions to this problem, see c:\Program Files\Microsoft Office\Office11\1033\Setup.chm

Solution
You have to download and install “Office 2003 web components” first and install SQL Server 2005 again; which then in my case cleared the error and installed successfully.
# Download: Office 2003 Add-in: Office Web Components – owc11.exe [ 17.6MB ]

After everything is done, remember to install Microsoft SQL Server 2005 Service Pack 2. Pheewww! That’s it!

No related posts.

Filed under: Bugs and Fixes, Notes, Software, SQL, Technology, Tools, VS.Net

RSS feed for comments on this post

22 Responses for "Installation Notes: SQL Server 2005 on Windows Vista with VS2008"

Larry Rapier February 27th, 2008 at 6:44 am 1
This worked for me too. Install the Office 2003 web components. You might need to start SQL services during the install.
Charles Henkel March 7th, 2008 at 10:34 am 2
I just went through essentially the same process.

Context: Vista Ulitmate x64
Initial: VS2005, no SQL Server
Goal: VS2008 with SQL Server 2005 Developer Edition

Uninstalled VS2005 completely

Installed SQL Server 2005 Developer and encountered the same IIS problems (and solutions) as you.
Installed SQL Server 2005 SP2
Installed VS2008
Installed MSDN Library for VS2008
Installed all Service Releases flagged by Windows Update

Issues:
1) Installation of SQL Server Developer apparently reinstalled the VS2005 Premier Partner Edition. Don’t really need it, and wonder if it will conflict with VS2008. Note that Windows Update does not flag the need for the VS2005 SP1 Update for Vista (KB932232). You have to download and install manually.

2) VS2008 installed SQL Express. Maybe I should have unchecked that option or something. Now have two SQL Servers. Can’t find any indication of SQL Express in Control Panel -> Programs and Features. Will it coexist with SQL Server Developer?

3) SQL Express cannot be administered from SSMS? Must you use SSMSE?
May March 7th, 2008 at 12:22 pm 3
@Charles Henkel,

1. Yes, that’s what I was confused about as well.
Seems like it has something to do with the Reporting services; MS doesn’t support SQL Server 2005 Reporting Services projects on VS2008, so have to separate from VS2008 solution and treat separately using the SQL Server 2005 “Business Intelligence Studio” which is included in “Visual Studio 2005 Premier Partner Edition”. If you uninstall that VS2005 since you think it’s unnecessary, it will not give you any error while installing SQL05 Dev BUT, it will not install “SQL Server Manage Studio” and some related components.
Therefore, you still need VS2005 Premier Edition while you’re using SQL2005 with VS2008. May be when you upgrade to SQL2008 then you can remove VS2005.

2. You are right, I didn’t notice it before. I just checked every possible components just to make sure everything work fine. I think it comes as a default package along with VS2008. May be you can uninstall it if you don’t need it, but for me I’ll just leave it as it is for the sake of some unforseen dependency issues with VS08.

3. You can administer SQL-Dev and SQL-Express using “SQL Server Management Studio” found under “All Programs” – “MS SQL Server 2005″ folder. I don’t see any SSMSE in my program menus though.
What you can do is, you can open SSMS the way you do normally, it should connect to your default SQL Server (SQL-Dev in my case). To administrator Express or lower SQL Server version such as SQL 2000, you just click “Connect” – “Database Engines” – from the “Server name” dropdownlist, then choose Express version or any other servers that you connected previously.
I’m managing SQL2000, SQL2005 Express and SQL2005 Dev all together in same SSMS.
Carlos March 8th, 2008 at 4:15 am 4
And what about the windows that shows something about the users that does not have privileges to manage or administer the database. The windows just pop-up after the installation. But it has nothing on it. Just the user name but didn’t have any privileges to select from so I’m stuck and don’t have SQL Server 2005 with SP2 running on my Vista x64 Ultimate any solution to that window again to see if this have the privileges. Thanks in advanced.
May March 8th, 2008 at 11:28 am 5
@Carlos,
Don’t really get what you mean. It’s best that you run with administrator mode. Login as administrator or right click on setup.exe and choose “Run as Administrator”.
Sorry may be that’s not what you’re looking for? I didn’t get any issues once I followed the ref-links steps as I mentioned in this post.
Carlos March 9th, 2008 at 9:37 am 6
Sorry for the mess I did up there.
But the point here was:
That when I finished with the installation. It just appears in a window a warning, saying something about permissions, that Vista doesn’t let the application to change them, so you have to do it manually. But there I got lost; because the warning provides a link to the application that let you add or remove some permission, but that windows (“the permission one”) was empty, so I could not add or remove anything; so I close it.
And I’ve been looking for that application (“the one with the permission setting”) but could not find it! So that is prettier to read I think!
diana March 15th, 2008 at 10:34 pm 7
pleaaaaaaaaaaaz some one help me and tell me in teps how to make sql server 2005 work in vista…i’m a beggener user to data base..and i didn’t understand what u said????
plzzzzzzzzzzz
Ivan March 21st, 2008 at 2:06 am 8
I am at my wits end too. I downlaoded SQL Server Express 2005, run it, and everything seemed to install fine. But the program itself is nowhere to be found on my machine. I have no idea what to do. I’m runnign Vista Business and so far I have enocuntered nothing but problems, first with Access databases not working under IIS, and now I can’t even get the SQL Express program to appear! Please help!
JohnPaul March 22nd, 2008 at 7:05 am 9
Thanks a lot..
Hurry.. after installed the owc11.exe in XP, sql server2005 installed smoothly..
Harry June 12th, 2008 at 4:44 am 10
I have gone thru the above posts thinkin my problem will be solved.. but no..

I recently took Dell xps and it came along with VISTA home edition, now when i try to install SQL SERVER 2005 on it, it gets installed smoothly but the services are not getting started for it, and when i trying to start it manually it gives me error and comes out.

Can any one help me.
lynnlynn June 14th, 2008 at 11:08 pm 11
hello .i can’t logn in SQL Sever 2005.error no is 18456.why ??please tell me about my error msg and send me my mail about it
Wilson July 21st, 2008 at 6:41 am 12
Hello,

On installing SQL 2000, found the compatibility issue so,
I tried to install the service pack 2 for getting sql 2005 installed on windows vista.
While installing I get a msg ” Please wait while set up searches for SQL instances on this computer”. After few secs , I get another msg that ” The machine doesnot have the product that matches this installation package”.

Please anyone help me to fix this problem and get SQL2005 installed on my computer.

Regards,
Wilson Sam
Vinod September 26th, 2008 at 9:14 pm 13
Hi Wilson,
PLZ chk the IIS is installed on ur machine, If not install it. For installing u need windows vista CD.
rushabh October 4th, 2008 at 4:59 pm 14
thank you for this artical.
It really helped me a lot.
It worked fine in my case.
I am using Windows vista Home Premium
Eury October 16th, 2008 at 3:36 am 15
Mi pregunta es… ¿el uso de la herramienta del office resulve todos los problemas de instalacion que te aparecen en la primera imagen?….. porque me salen todos esos problemas………

ademas, que acerca de la autenticacion….. debe ser obligatoria de SQL…

Gracias desde ahora…
James O December 2nd, 2008 at 7:33 pm 16
I have tried but have been unable to install sql server 2005 enterprise on window vista. it complain of operating system error. Does it mean that it cannot be installed?
Ashwin Juvva January 7th, 2009 at 8:42 am 17
James,

Enterprise edition will be installed on windows server 2003 or windows 2000 server . You cannot install directly on vista. Where as the developer edition can be installed on vista.
Frank Silva January 10th, 2009 at 9:20 am 18
any body knows how to enable reporting projects of SQL2005 in VS2008? I have everything installed but when i installed VS2008 it does not recognize nothing of reporting services, and the application should be made on 3.5 FW, and i prefer VS2008 for its incredible facilities for coidng, but the app also needs reporting services on SQL2005 and I’m kinda worry
Atul February 10th, 2009 at 12:30 am 19
Please help me out how to install Sql server 2005 on vista?Reply..I am just a beginner.
xya February 10th, 2009 at 6:42 pm 20
please helpme how to install sql server 2005 on vista.. I am a bigger

thanks
imran March 10th, 2009 at 7:47 pm 21
I was installing SQL Server 2008 Small Business edition on Vista Ultimate with Visual Studio 2008 express edition already been installed. Everything went fine in the installation of SQL Server 2008 till the end when i get the error message that the current version of SQL Server doesn’t support my windows version.

I am just shooting in dark here. Anyone…
Akbar Moradi April 22nd, 2009 at 6:37 pm 22
Please help me

I can not install sqlserver2005 to vista

thanks