Microsoft SQL Server 2008 Express with Tools

Version: 10
Views: 4.3k  |  Created: 08/23/2008

Average Rating: 0
SQL Server 2008 Express with Tools has 1 inventory records, 0 Questions, 0 Blogs and 2 links. Please help add to this by sharing more!

Deployment Tips (4)

Most Common Setup Type
Not Determined
Average Package Difficulty Rating
Rated 3 / 5 (Average) based on 1 ratings
Most Commonly Reported Deployment Method
Vendor Provided Command Line (switch driven)
or cancel
135
Command Line
Step 1: Install Microsoft .Net Framework 3.5 SP1
Step 2: Install Windows Installer 4.5.
Step 3: Install Windows PowerShell 1.0.
Step 4: Extract files from SQLEXPRWT_x[ARC]_ENU.exe

http://www.microsoft.com/downloads/details.aspx?FamilyId=7522A683-4CB2-454E-B908-E805E9BD4E28&displaylang=en


Usage:
setup.exe /[option]={value} /[option]={value} ...

Options:
ACTION Specifies a Setup work flow, like INSTALL, UNINSTALL,
or UPGRADE. This is a required parameter.
ADDCURRENTUSERASSQLADMIN Provision current user as a Database Engine system
administrator for SQL Server 2008 Express.
AGTDOMAINGROUP Either domain user name or system account
AGTSVCACCOUNT Either domain user name or system account
AGTSVCPASSWORD Password for domain user name. Not required for
system account
AGTSVCSTARTUPTYPE Either 1 or 0
ALLINSTANCES Specifies that all instances are to be included in
the Setup operation. This parameter is only supported
when applying a patch.
ASBACKUPDIR The location for the Analysis Services backup files.
ASCOLLATION The collation used by Analysis Services.
ASCONFIGDIR The location for the Analysis Services configuration
files.
ASDATADIR The location for the Analysis Services data files.
ASDOMAINGROUP Specifies the Analysis Services domain group name.
ASLOGDIR The location for the Analysis Services log files.
ASPROVIDERMSOLAP Specifies if the MSOLAP provider can run in process.
ASSVCACCOUNT The account used by the Analysis Services service.
ASSVCPASSWORD The password for the Analysis Services service
account.
ASSVCSTARTUPTYPE Controls the service startup type setting for the
service.
ASSYSADMINACCOUNTS Specifies the list of administrator accounts to
provision.
ASTEMPDIR The location for the Analysis Services temporary
files.
BROWSERSVCSTARTUPTYPE Startup type for Browser Service.
CONFIGURATIONFILE Specifies the configuration file to be used for
Setup.
ENABLERANU Set to "1" to enable RANU for SQL Server Express.
ERRORREPORTING Specify if errors can be reported to Microsoft to
improve future SQL Server releases. Specify 1 or True
to enable and 0 or False to disable this feature.
FAILOVERCLUSTERDISKS Specifies a cluster shared disk to associate with the
SQL Server failover cluster instance.
FAILOVERCLUSTERGROUP Specifies the name of the cluster group for the SQL
Server failover cluster instance.
FAILOVERCLUSTERIPADDRESS Specifies an encoded IP address. The encodings are
semicolon-delimited (;), and follow the format <IP
Type>;
;<network name>;<subnet mask>.
Supported IP types include DHCP, IPV4, and IPV6.
FAILOVERCLUSTERNETWORKNA Specifies the name of the SQ LServer failover cluster
instance. This name is the network name that is used
to connect to SQL Server services.
FAILOVERCLUSTERROLLOWNER Specifies whether the upgraded nodes should take
ownership of the failover instance group or not. Use
0 to retain ownership in the legacy nodes, 1 to make
the upgraded nodes take ownership, or 2 to let SQL
Server Setup decide when to move ownership.
FEATURES Specifies features to install, uninstall, or upgrade.
The list of top-level features include SQL, AS, RS,
IS, and Tools. The SQL feature will install the
database engine, replication, and full-text. The
Tools feature will install Management Tools, Books
online, Business Intelligence Development Studio, and
other shared components.
FILESTREAMLEVEL Level to enable FILESTREAM feature at (0, 1, 2 or 3).
FILESTREAMSHARENAME Name of Windows share to be created for FILESTREAM
File I/O.
FTSVCACCOUNT User account for Full-text Filter Daemon Host.
FTSVCPASSWORD User password for Full-text Filter Daemon Host
account.
FTUPGRADEOPTION Full-text catalog upgrade option.
HELP Displays the command line parameters usage
INDICATEPROGRESS Specifies that the detailed Setup log should be piped
to the console.
INSTALLSHAREDDIR Specify the root installation directory for native
shared components.
INSTALLSHAREDWOWDIR Specify the root installation directory for the WOW64
shared components.
INSTALLSQLDATADIR The Database Engine root data directory.
INSTANCEDIR Specify the instance root directory.
INSTANCEID Specify the Instance ID for the SQL Server features
you have specified. SQL Server directory structure,
registry structure, and service names will reflect
the instance ID of the SQL Server instance.
INSTANCENAME Specify a default or named instance. MSSQLSERVER is
the default instance for non-Express editions and
SQLExpress for Express editions. This parameter is
required when installing the SQL Server Database
Engine (SQL), Analysis Services (AS), or Reporting
Services (RS).
ISSVCACCOUNT Either domain user name or system account.
ISSVCPASSWORD Password for domain user.
ISSVCSTARTUPTYPE Automatic, Manual or Disabled.
MEDIASOURCE Specifies the path to the installation media folder
where setup.exe is located.
NPENABLED Specify 0 to disable or 1 to enable the Named Pipes
protocol.
PID Specify the SQL Server product key to configure which
edition you would like to use.
QUIET Setup will not display any user interface.
QUIETSIMPLE Setup will display progress only without any user
interaction.
RSCATALOGSERVERINSTANCEN The SQL Server server for the report server catalog
database.
RSINSTALLMODE Specifies the installation mode for the report
server. Valid values include Default,
DefaultSharePoint, and FilesOnly. The default value
for InstallMode is FilesOnly.
RSSVCACCOUNT Specify the service account of the report server.
This value is required. If you omit this value, Setup
will use the default built-in account for the current
operating system (either NetworkService or
LocalSystem). If you specify a domain user account,
the domain must be under 254 characters and the user
name must be under 20 characters. The account name
cannot contain the following characters:
" / \ [ ] : ; | = , + * ? < >
RSSVCPASSWORD Specify a strong password for the account. A strong
password is at least 8 characters and includes a
combination of upper and lower case alphanumeric
characters and at least one symbol character. Avoid
spelling an actual word or name that might be listed
in a dictionary.
RSSVCSTARTUPTYPE Specifies the startup mode for the Report Server
service. Valid values include Manual, Automatic, and
Disabled. The default value for StartupType is
Manual, where the server is started when a request is
received.
RSUPGRADEDATABASEACCOUNT Specify the account used to access the existing
report server catalog database. This value is
required. If you omit this value, Setup will use the
default built-in account for the current operating
system (either NetworkService or LocalSystem). If you
specify a domain user account, the domain must be
under 254 characters and the user name must be under
20 characters. The account name cannot contain the
following characters:
" / \ [ ] : ; | = , + * ? < >
RSUPGRADEPASSWORD Specify a strong password for the account. A strong
password is at least 8 characters and includes a
combination of upper and lower case alphanumeric
characters and at least one symbol character. Avoid
spelling an actual word or name that might be listed
in a dictionary.
RULES Specifies the list of rule IDs or rule group IDs to
run.
SAPWD Password for SQL Server sa account.
SECURITYMODE The default is Windows Authentication. Use "SQL" for
Mixed Mode Authentication.
SQLBACKUPDIR Default directory for the Database Engine backup
files.
SQLCOLLATION Specifies a Windows collation or an SQL collation to
use for the Database Engine.
SQLDOMAINGROUP Domain group name for Windows Server 2003 failover
instance.
SQLSVCACCOUNT Account for SQL Server service: Domain\User or system
account.
SQLSVCPASSWORD A SQL Server service password is required only for a
domain account.
SQLSVCSTARTUPTYPE Startup type for the SQL Server service.
SQLSYSADMINACCOUNTS Windows account(s) to provision as SQL Server system
administrators.
SQLTEMPDBDIR Directory for Database Engine TempDB files.
SQLTEMPDBLOGDIR Directory for the Database Engine TempDB log files.
SQLUSERDBDIR Default directory for the Database Engine user
databases.
SQLUSERDBLOGDIR Default directory for the Database Engine user
database logs.
SQMREPORTING Specify that SQL Server feature usage data can be
collected and sent to Microsoft. Specify 1 or True to
enable and 0 or False to disable this feature.
TCPENABLED Specify 0 to disable or 1 to enable the TCP/IP
protocol.
X86 Specifies that Setup should install into WOW64. This
command line argument is not supported on an IA64 or
a 32-bit system.

Full unattended installation example, showing all required parameters:


setup.exe /Q /ACTION=install /PID=<validpid> /FEATURES=SQL,AS,RS,IS,Tools
/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"
/SQLSVCPASSWORD="************" /SQLSYSADMINACCOUNTS="MyDomain\MyAccount "
/AGTSVCACCOUNT="MyDomain\MyAccount" /AGTSVCPASSWORD="************"
/ASSVCACCOUNT="MyDomain\MyAccount" /ASSVCPASSWORD="************"
/RSSVCACCOUNT="MyDomain\MyAccount" /RSSVCPASSWORD="************"
/ISSVCAccount="MyDomain\MyAccount" /ISSVCPASSWORD="************"
/ASSYSADMINACCOUNTS="MyDomain\MyAccount"
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
6
Command Line
/SKIPRULES=RebootRequiredCheck

This will skip the reboot prerequisite check. You can install the prerequisites with noreboot then launch the setup for a automated install. Reboot is recommended at the end of the install.
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
2
Note
If trying to deploy to Windows 7 you will recieve the "Program Compatibility Assistant" and will be told this is not compatable and needs SP1 loaded after the completed install.

To get around this you can click on the option "Dont show this message again" then exit out of the install. This created a reg. file that can be imported ahead of time to stop this notifaction. see link below:

http://support.microsoft.com/kb/931709/en-gb

Here's my reg. example:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags]
"{f2d3ae3a-bfcc-45e2-bf63-178d1db34294}"=dword:00000004
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment
1
Note

One thing i noticed while deploying SQL Express 08 is that it does not like using %~dp0 from within an install script, i had to revert to calling a UNC path from within the install script.

IE:

@echo off
\\<FileServer\SourceDirectory>\SQLEXPR_x64_ENU.exe /ACTION=INSTALL /FEATURES=SQLEngine /INSTANCENAME=EXAMPLE1 /SQLCOLLATION=Latin1_General_BIN /SQLSVCSTARTUPTYPE=Automatic /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /IAcceptSQLServerLicenseTerms="True"  /Q
exit

 

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s): Windows
Please log in to comment

Inventory Records (1)

View inventory records anonymously contributed by opt-in users of the K1000 Systems Management Appliance.

Versions

SQL Server 2008 Express with Tools

Version

10

Questions & Answers (0)

Questions & Answers related to Microsoft SQL Server 2008 Express with Tools

Blogs (0)

Blog posts related to Microsoft SQL Server 2008 Express with Tools

Reviews (0)

Reviews related to Microsoft SQL Server 2008 Express with Tools