Silent install / Command line install of SQL Server 2005 Part 2

Today I started my second attempt of silent / command line installation of SQL Server 2005 September CTP.

I guess I should have mentioned in Part 1 that that install was attempted on Win XP Pro, SP1. This time I worked on a clean machine with a fresh Windows 2003 Standard Edition. This machine has 2 Intel Pentium 4 2.59 GHz processors and 1 GB RAM.

So, as in described in Part 1, I went to command line and fired the command.

2 seconds later, I got a message saying that this version of OS or Service Pack is not supported. All right, I pulled out my Windows 2003 Service Pack 1 DVD and installed that. I then started command line install again. So remember, SP 1 is needed on Windows 2003 prior to install.

It appeared to work initially. It looked like that prerequisite components were part of Service Pack 1, because this time it didn’t not ask for it. Therefore no mindless clicking was needed. The CD-Rom was spinning. Visual check of task manager showed there was a setup.exe process going. Would it succeed this time?

Not so fast:(. About 1 or 2 minutes later, CD-Rom stopped spinning and hard drive indicator stopped blinking. Could it finish so fast? I looked at Start->Program Files and nothing was there. I then looked at installation log file located at %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. Below is the message I got:

KJLLJFD-3J6YDPO : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features.  Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

This is really annoying. Based on BOL, none of the components I selected in my .ini file requires IIS. Yet silent install stopped because IIS was not there. In GUI install, this is presented as a warning, but you can choose to ignore the warning and click Next and continue installation. In fact, that was what I had to do today to load it on this machine.

Oh well, this is disappointing. I will see how to file this as a bug to Microsoft, if it has not been done already.

 

Silent install / Command line install of SQL Server 2005 Part 1

If you’ve read my articles, you know that I am a big fan of automation. I got a big kick out of seeing somebody else (in this case, machines) doing the real work;) With that in mind, I set out to automate the installation process of SQL Server 2005 September CTP.

SQL Server 2005 provides silent / command line installation. You have the option of setting all parameters in one command line and run it, or providing all settings in an .ini file. If you take the former approach, you will have a long command line to type and it is not easily reusable. If you take the later approach, you will have a config file to work with. It is reusable and customizable. Not surprisingly, I took the later approach.

So I read BOL for setup, looked through various parameters, and came up with my own .ini file. Here is the content of it:
[Options]
USERNAME=Alex
COMPANYNAME=Alex

[ADDLOCAL]
ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SQL_Profiler90,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy,SQL_Documentation,SQL_BooksOnline,SQL_SQLServerBooksOnline,SQL_Samples,SQL_AdventureWorksSamples,SQL_Samples

[INSTANCENAME]
INSTANCENAME=MSSQLSERVER

[AUTOSTART]
SQLAUTOSTART=1
AGTAUTOSTART=1

[SECURITYMODE]
SECURITYMODE=SQL
SAPWD=MakeItAStrongPassword

Now I am all set to go. I ran this command, hoping I could go take a nap and have a sweet dream and when the dream is over it would be all done:
D:\SQL Server x86\Servers>setup /settings H:\TechnicalStuff\Database\MSSQL\SQL2005\Installation.ini qn

Surprise, about 2 seconds after I pressed the Enter key, up popped a Window asking me to install the prerequisites. I had to endure the pain of mindless clicking after all. Adding injury to insult, this process bombed out at the second step, installing Microsoft SQL Native Client:(

Suggestions to Microsoft: in the RTM CD/DVD, it would be very helpful to customers if you provide a sample setup .ini file for silent installation. But, if Microsoft does not do that, you can use my sample posted above as a start;)

Questions to you and Microsoft: is it possible to include installation of prerequisites components as part of silent install? Email me or add a comment if you know the answer.

Alas, I will try this again on a clean machine when I get a chance.

Stay tuned…

Utility to remove Beta 2 and previous CTPs

If you have previous Beta or CTP versions of SQL Server 2005 installed and you’d like to play with the September CTP, Microsoft provides an utility to cleanly remove the older version and .Net Framework. The utility is called sqlbuw.exe, located at CD-Rom\SQL Server x86\Tools\Setup Tools\Build Uninstall Wizard.

It worked great for me on both my laptop and desktop. On my laptop, I had Beta 2; on desktop, June CTP.