Setup Options for SQL Server 2005 Express Edition



I have a setup package that I built with VS 2005. I selected three
prerequisites in the package, .Net Framework version 2.0, MSI Installer
version 3.1, and Sql Server 2005 Express Edition.

I was wondering if I can specify the SECURITYMODE and
DISABLENETWORKPROTOCOLS setup options that were available with MSDE
2000. I tried to add them on the command line when I executed the setup
bootstrapper, but they didn't work.

setup SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

So I was forced to change the registry by hand and use the SQL Server
Configuration Manager to enable TCP/IP.

Isn't there a way to specify these settings from the command line or a
setup.ini file, like we had with MSDE 2000? If so, is a sample
SETUP.INI file available? I need to automate these settings so the
installation is easier.

If not, how do I set the disabled network protocols programmatically
from a custom action? I figured out how to set the security mode
programmatically by updating the registry, but this will only work if
the installation is the first named instance.

It takes 30 minutes to install SQL Server 2005 Express Edition on older
machines. The last thing I want is to complicate the user's
installation any further.

.



Relevant Pages

  • Re: update rollup refuses to unstall on my pc {?}
    ... Condition Check for Line 2 of PreRequisite returned FALSE ... 0.188: ReadStringFromInf: UpdSpGetLineText failed: 0xe0000102 ... 0.188: KB925766 Setup hat folgenden Fehler festgestellt: Setup kann nicht ... da eine oder mehrere Anforderungen für die Installation ...
    (microsoft.public.windows.mediacenter)
  • RE: Error Code: 1073807364 sql server 2005
    ... contain the files that are required during the installation of SQL Server ... In the D:\SQLServer2005 folder, ... Setup.exe to start the SQL Server 2005 Setup program. ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot install 2005 Developer Edition x64 on new XP x64
    ... OS Name MicrosoftWindowsXP Professional x64 Edition ... and try to run the Setup from the media yourself. ... corrupted SQL Server installation and then try to run SQL Server Setup ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Tools Setup Failure
    ... I also had to struggle with this strange error during the installation ... of SQL Server 2005 SP1 Express Edition on a clean Windows XP ... Online and Developments tools. ... The setup keeps failing with the error "SQL Server Setup is unable to ...
    (microsoft.public.sqlserver.setup)
  • RE: weird sql server 2000 setup problem
    ... Its possible that some unnecessary service is affecting the setup. ... Before you begin the installation process, ... For a complete list of supported hardware, visit the following Microsoft Web site: ... *You have disabled NetBIOS for all private network cards before you start the SQL Server Setup program. ...
    (microsoft.public.sqlserver.clustering)