Installation on Vista

Hi, I have a serious issue installing sql server express (advanced edition) on Windows Vista Home Premium. I'm doing the install with elevated priviledges but setup of the sql server always fails at the same point with the following error:

{Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'

I've tried many different combinations, including advanced installation options selecting sql server instance to run as local system or local server but nothing came out of that. I always select add current user to the sql server administrators group.
Any help on this issue is appreciated. Below follows the setup summary log:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Mon Feb 26 22:02:41 2007
Machine : JUPITER
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLSupport_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLNCLI_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SqlWriter_1.log
--
Machine : JUPITER
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--
Machine : JUPITER
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
--

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Mon Feb 26 22:30:02 2007

I'm really new to the whole SQL thing too.

Also had trouble with installation as well.

It's weird how they don't tell you to setup the app correctly.

There are two ways I believe to set up the app as an administrator.

The easiest for me was to goto "All Programs" in the start bar and right-click on the SQL Management application and they click "Run as Administrator"

Maybe it might launch correctly. It did for me.

Or I remember with Win XP days that you could boot and hit one of the function keys (I think F2) that would normally take you to Safe Mode but gives you the option to log onto as a system administrator as well.

Maybe that may work for Vista as well. Once you log in as system administrator you can open SQL Management and add your user windows account as a sysadmin through the app to give you correct permissions.

Hope any of that was readable and somewhat understandable.|||

Hi, Amie.

Thank you for the tip, but the trouble is that this error occurs during the installation fase of the sql engine, so installation fails and it rolls back, which essentially means that the sql instance fails to run, so there is no server to manage. :-(

|||

Hi Zzermont,

Are you installing a new instance of SQL or upgrading an existing installation? If you are upgrading an existing installation I would guess that you are trying to select SQL Authentication during the upgrade process, which is not supported. If this is a new installation, I'm not sure what's going on. I've installed SQL Express successfully on Vista a number of times.

Either way, I'm pushing this message over to the Setup forum for more directed help.

Mike

|||

Hi, Mike.

It is a new installation on vista. The only thing to note is that I have Visual Studio 2005 SP1 installed (with sql server deselected at installation time).

Alek