TechOnTip Weblog

Run book for Technocrats

Install SQL 2008 on a Windows 2008 Server from Commad Line & Answer File

Posted by Brajesh Panda on January 6, 2010

I have two methods for you;

  1. Silent Installation from Command Prompt
  • Using command syntaxes
  • Using Answer File

2.         GUI Based Installation

 I will be covering small step to uninstall process using command line at the end of the post. Don’t forget to install SQL Server 2008 SP1 after you install the RTM.

 1st time I have followed GUI Method but found little time consuming. Hence built my small script to do the same from command line. MSDN website has a fantastic page regarding “How to: Install SQL Server 2008 from Command Prompt” . Take your time & do your research on all parameters from that page.

 Let me give you post about Command line Installation of SQL Server

 Install SQL Server 2008 on a Windows 2008 Server Using Command Line Syntaxes

##### Install Perquisites ######

 servermanagercmd -i NET-Framework-Core

servermanagercmd -i NET-HTTP-Activation

servermanagercmd -i NET-Non-HTTP-Activ

 ##### Install SQL Server with a Default Instance. Full Blown Installation with some Client Management Features ######

 Setup.exe /q /ACTION=Install /ERRORREPORTING=0 /FEATURES=SQL,RS,AS,IS,SSMS,ADV_SSMS,Conn /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT=”NT AUTHORITY\Network Service” /SQLSYSADMINACCOUNTS=”BUILTIN\ADMINISTRATORS” /SQLSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT=”NT AUTHORITY\Network Service” /AGTSVCSTARTUPTYPE=Automatic /RSSVCACCOUNT=”NT AUTHORITY\Network Service” /RSSVCSTARTUPTYPE=Automatic /ASSVCACCOUNT=”NT AUTHORITY\Network Service” /ASSVCSTARTUPTYPE=Disabled /ASSYSADMINACCOUNTS=”BUILTIN\ADMINISTRATORS /ISSVCACCOUNT=”NT AUTHORITY\Network Service” /ISSVCSTARTUPTYPE=Disabled

Parameter Details
/q Quite, No User Input
/ERRORREPORTING=0 Don’t send errors to MS
/FEATURES Define Features
SQL SQLEngine, Replication, FullText
RS Reporting Services
AS Analysis Service
IS Integration Service
Tools Client Management ToolsSSMS-Basic, ADV_SSMS-Complete, Connectivity
/INSTANCENAME Instance Name

 Apart from this I have configured “BUILTIN\ADMINISTRATORS” as System Admin Accounts. Make sure you are changing this parameter. May be you not like to give rights to specific people.

 My script is installing everything into default “C:\Program Files” location. If you want to install it in a different location refer to directory switches on MSDN document. My script is also creating a default instance named as MYSQLSERVER. Change your name.

 SQL & AS needs System Admin accounts to be defined. Refer to Problem 1 in the end of the post.

 Install SQL Server 2008 on a Windows 2008 Server Using Answer File

 Setup.exe /ConfigurationFile=MyConfigurationFile.INI

 Download a template file from my Google docs

 Uninstall SQL 2008 Using Command Line

 Setup.exe /Action=Uninstall /FEATURES= SQL,RS,AS,IS,SSMS,ADV_SSMS,Conn /INSTANCENAME=MSSQLSERVER

 Note:    After you uninstall & if you like to reinstall SQL 2008 server you may face problem

 Trouble Shooting

 Problem 1:

At least define one system admin account.

Error Result: -2068578304  

 Problem 2:

A computer restart is required because of broken fusion ATL. You must restart your computer before you continue.

Error result: -2067919934

Result facility code: 1214

Result error code: 3010

Solution: Refer to KB955792. In this case locate “Sqlsupport.msi” from your installation media & install it.

 Problem 3:

The Reporting Services catalog database file exists. Select a Reporting Services

 files-only mode installation.

 Error result: -2067921932

Result facility code: 1214

Result error code: 1012

Solution: Refer to KB956095

 Problem 4

After uninstallation I have deleted all un removed folders but when I tried to reinstall, installer was not doing anything. So manually I have installed SQLsupport.msi

 Don’t mind to leave a comment, if you like this post. Any suggestions most welcome!

Advertisements

5 Responses to “Install SQL 2008 on a Windows 2008 Server from Commad Line & Answer File”

  1. Joe Wong said

    My workaround on the “broken fusion ATL” problem is to install KB 973544 (VC++ 2005 Security hotfix package x64) on the machine first. It put the correct VC80.ATL library in GAC, and so the fusioncheck.dll is able to correct perform the ATL checking.

  2. mafri.ws said

    MAFRI…

    […]Install SQL 2008 on a Windows 2008 Server from Commad Line & Answer File « TechOnTip Weblog[…]…

  3. Alexandra said

    Hi there colleagues, how is all, and what you want to say about this post, in my view its in fact remarkable in favor of
    me.

  4. Hi there i am kavin, its my first occasion to commenting anyplace, when i read this
    paragraph i thought i could also make comment due to this brilliant piece of
    writing.

  5. I’m not sure exactly why but this blog is loading very slow for me. Is anyone else having this problem or is it a problem on my end? I’ll check
    back later on and see if the problem still exists.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: