Installing SQL Server 2005 on Windows VISTA ULTIMATE

Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error:

- SQL Server Edition Operating System Compatibility (Warning)

Messages

SQL Server Edition Operating System Compatibility

Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.

Please help.

Sql Server 2005 without SP2 on Vista isn't supported by Microsoft. You can install it, it works, but you should install SP2 as soon as it comes out.|||

Right...but for SP2 it should allow me to install SQL Serevr2005 1st.

It's giving me the warning and on moving ahead it's not giving me option to installing SQL Components (SQL Server, Analisys Server, Reporting Services etc.)...what I am getting is just to install Native Client.

|||

Hi Amit,

Does your system have IIS 7.0 Installed on it ?! refer http://support.microsoft.com/kb/920201 fore more!!

would you tell which version of SQL 2005 you are trying to install ?

HTH

Hemantgiri S. Goswami

|||I have recieved errors when installing sql server 2005 also. When configuring the database services the first error says it cannot find a user and then everything fails after that. For the most part the only people that are loading vista rtm are developers. Will a new install of sql server 2005 be coming out soon that works.|||

Hi,

Have you reffered my answer!!!

|||

SQL Server 2005 installs fine on Vista if you have added IIS 7

Else it allowed me only client installation

|||

I had IIS 7 installed. The first time was a clean install of vista with iis 7. I tried IIS running without IIS 6 compatibility and with it. During the setup of db services it fails to find the user. I am using the local system account option to install. I confirmed IIS was installed both times before installing sql server 2005 by using the browser and looking at http://localhost.

|||

Are you running the setup as a local administrator?

|||

Yes, I log onto the system as local administrator. During the install I select local account rather domain. When the install setups the db service I get the error that it cannot find the local sql server account. The account is something like this:

"\USERNAME\SQLServer2005MSFTEUser$USERNAME$MSSQLSERVER".

My machine name and acount name are the same so in the format above the first "USERNAME" might be machine name. But it does not find the account and things fail after that. I also have to unplug the network cable because the install cannot hangs when setting file security. I have seen that issue with other installs also in the news groups.

|||

Can you use your domain account for the installation (after making yourself a local administrator of the machine) and keep it connected to the network during the installation?

Or else, is it possible you are using a test version of Vista? Or perhaps you haven't installed a software requirement for SQL 2005? Or forgot SQL 2005 CTP SP2?

Just a thought...

|||

I am the local administrator on my machine even on my domain account. I have to unplug from the network when installing on vista or win xp. I am certain that I am using vista rtm not a test version. All of the software requirements needed are installed on the the vista system prior to install the sql server 2005 install verifies that. You cannot install the ctp sp2 untill you have installed sql server.

I even went backwards and installed win xp w/sp2 (with iis6) and then installed sql server 2005 with ctp sp2. Finally I upgraded to vista. Then when I started checking iis 7 i ran into other problems. IIS 7 said it could not run because the WAS and web publishing services weren't running. So I checked and they were. I tried unstalling and re-installing iis 7, and when I tried to start it, it complained the web publishing service was running. So I stopped it and it complained it wasn't running. At that point after five days of trying I threw up my hands in disgust and went back to win xp sp2.

I could not believe that all of the application compatiblily testing had not included vs 2005 , sql server 2005 and the iis 7 upgrade. All of this and google searches have led me to believe they need a new install for sql server 2005 not just a service pack. Needing to unplug the network cable during install is not a new issue I have talked to other developers who have seen the same thing. Add all of this together with vista's UAC makes for bad user experiences.

Also I don't want to use my domain account because I am running on a laptop. I am only hooked into my domain at work a small percentage of the time. I believe it would work but I prefer the local account.

|||I take it you are trying to install SQL 2005 Enterprise which is only compatible with the Server Operating systems. If you try installing SQL 2005 Standard edition or lower then you will be able to install SQL server components as well.|||

I believe you can solve your problem by right clicking the Program on your Start Menu and selecting Start as Administrator. Even though you log in to Vista with an administrator account, it seems to run in a shell that imitates a non-administrator. That's why you receive all those notices when you install software asking for your permission.

New Issue:

I was surfing because I am having a problem installing the Database Engine required to attach databases. I have uninstalled and paid more attention on my reinstall and the install routine and all goes smoothly until the actual install wants to start and it tells me that SQL Server Database Services 8.00.761 are already installed. Reading the details further says...

Name: Microsoft SQL Server 2000 (MSSQLSERVER)

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

I have uninstalled anything I can find with SQL in it. THE KEY TO THE PROBLEM? The Programs listing shows me an instance of Microsoft SQL Server Desktop Engine version 8.00.761, but I cannot uninstall it. It starts the uninstall procedure and then dies. Any ideas?

|||

Hi,

You can install fresh / New copy of SQL 2005 as both MSDE and SQL 2005 Express can be installed on the same machine, how ever have you try Manual Un Installtion ?! Refer below guidelines for the same: http://support.microsoft.com/kb/290991/

Hemantgiri S. Goswami