How to do silent installation of SQL Server Express

-
Hi guys ,

 This post is about the silent installation of SQL Server Express Addition..

 I was searching for "SQL Installation using Command Prompt" 
and i got something very interesting on Technet Forums to do it.. 

More Info:
 http://social.msdn.microsoft.com/Forums/sqlserver/en-US/835c123e-7c3e-4eef-bc47-e2ee700187c1/sql-server-express-silent-installation

How you can do it

 To install SQL Express in quiet mode

 open Command Prompt with Administrative privileges 

 type the following Command line

 
Setup.exe /q /Action=Install /Hideconsole /Features=SQL,Tools
/InstanceName=SQLExpress /SQLSYSADMINACCOUNTS="Builtin\Administrators"
/SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>

In the preceding example:
  • /q– specifies that Setup run in a quiet mode without any user interface.
  • /Action– specifies which action to perform. In this example, the action is Install.
  • /Hideconsole– specifies that the console window is hidden or closed during the install.
  • /Features– specifies which parent features and features to install. In this example, the parent feature SQL is installed, which includes SQLEngine, Replication, and Fulltext components. The Tools feature installs all of the tools components.
  • /InstanceName– specifies a SQL Server instance name.
  • /SQLSYSADMINACCOUNTS–provisions logins to be members of the system administrators role.
  • /SQLSVCACCOUNT– specifies the startup account for the SQL Server service.
  • /SQLSVCPASSWORD– specifies the password for SQLSVCACCOUNT.


You can use /QS switch as an installation parameter, the /QS switch only shows progress,

Cheers...

Comments

Post a Comment

Popular posts from this blog

Windows Deployment Service ( WDS ) and Errors and Solutions

-
Image
Hi Guys... This post is all about Windows Deployment service WDS and its Errors and solutions. WDS is used to deploy Operating System Images and also is SCCM OSD Component. Many times we all have faced WDS issues and errors. Following are Some of Issues and their solutions Error 10048 Description: The Windows Deployment Services Server service terminated with service-specific error 10048 This issue occurs if the following conditions are true: ·          The DHCP server and the WDS server are installed on the same computer. ·          The  Do not listen on port 67  option is  NOT  enabled in the DHCP tab. Cause When the DHCP server and the WDS server are installed on the same computer, the WDS Service tries to use the port 67. However, the DHCP server already uses this port. Solution: Method 1 At the command prompt, type the following command, and then press ENTER: wdsutil /set-Server /UseDhcpPorts:No Method 2 1.       Click  Start , click
Read more

Hyper-V Questions and answers !

-
Hyper-V Questions and answers ! VIRTUAL MACHINE TECHNOLOGY Q.   What is virtual machine technology? A.    Virtual machine technology applies to both server and client hardware. Virtual machine technology enables multiple operating systems to run concurrently on a single machine. In particular, Hyper-V, a key feature of Windows Server 2008 R2, enables one or more operating systems to run simultaneously on the same physical system. Today, many operating  systems are supported by Virtual PC 2007, Virtual Server 2005, and Hyper-V. Q.   What is virtual machine technology used for? A.    Virtual machine technology serves a variety of purposes. It enables hardware consolidation, because multiple operating systems can run on one computer. Key applications for virtual machine technology include cross-platform integration as well as the following: Server consolidation. If several servers run applications that consume only a fraction of the           avail
Read more

DHCP, WDS, PXE Boot and Common Issues

-
Image
Hi Guys, Again i am back with very common information about DHCP,WDS & PXE and issues troubleshooting and their solutions. DHCP, WDS, and PXE are the main and needed components which plays very important role in SCCM OSD. They function and provide a very cool and automatize the OS installations (Network based). So why is the Need? DHCP : DHCP offers automatic ip address assigning functionality to machines at both booting state and online state. DHCP Scope options are one main key component. WDS : WDS offers the PXE functionality (Not SCCM) for network based OS installation (boots machine in to windows installation mode from network) So when we install the SCCM PXE service Point on WDS Server, It just overrides the settings of WDS PXE. Now Common PXE Boot Issues: ·         PXE-E53: No boot filename received   ·         PXE-T01: File not found ·         PXE-E3B: TFTP Error - File not Found   ·         PXE-E55 Proxy DHCP Service did no
Read more