SQL Server 2005 - Unattended installation - Part V

August 2, 2006

Service pack install - Server and Client Components

In Part I, Part II and Part III of this series, you have seen how to install SQL Server client components, server components using command line parameters and using configuration file such as .ini. In Part IV, we discussed how to patch the SQL Server client machine with SP1.

In this section of this series, I am going to demonstrate how to install SQL server 2005 service pack 1, to update the server components using command line options.

Imagine that we have one database instance, "JANE," and one Analysis service instance, "JANE," on the same host, "KUROZAWA". Connect to both instances using SQL Server Management studio. You can see the following connections on the object browser. Refer Fig 1.0.

Please notice the version number of both Database Service and Analysis Service that you are connected to are 9.00.1399 and 9.00.1399.06 respectively.

Step 1

Open SQL server management studio and connect to the database engine instance that you want to patch. Right click on the server and click on properties. If you have RTM version, it will display the following message. Refer Fig 1.1.

Please notice the version number of the Database Service instance that you are connected to. It is 9.00.1399.

Step 2

Create folder C:\install on the workstation or create this folder on a fileserver.

Note: Create the folder and select the drive according to the availability in your environment.

Step 3

Download SQL Server 2005 Service Pack 1 (SQLServer2005SP1-KB913090-XXX-LLL.exe) from www.microsoft.com/sql and save the file to C:\install or on to the network shared drive. Refer Fig 1.2.

Step 4

Click on the Start button on the task bar, click run, type the command CMD.exe, which opens the MS-DOS shell command prompt.

Step 5

You may skip step 5 and 6, if you do not want to see the options available in running setup and the report only option, which shows all the components that will be upgraded when we run this install. Refer Fig 1.3.

Execute the following command:

C:\install\SQLServer2005SP1-KB913090-x86-ENU.exe /?

Or

\\fileserver\shareddrive\SQLServer2005SP1-KB913090-XXX-LLL.exe /?

When the above command is executed, it will display all the command line parameters available. Refer Fig 1.4, Fig 1.5 and Fig 1.6.

Step 6

You may skip this step and Step 5, if you do not want to see the options available in running setup and the report only option, which shows all the components that would be upgraded when we run this install

Execute the following command. Refer Fig 1.7.

C:\install\SQLServer2005SP1-KB913090-x86-ENU.exe /reportonly

If you are using a network share then type the following command:

\\fileserver\shareddrive\SQLServer2005SP1-KB913090-XXX-LLL.exe /reportonly

Note: Update the name of the fileserver with your actual fileserver name and update the shared drive name accordingly.

You will see the following information on the screen. Refer Fig 1.8, Fig 1.9 and Fig 2.0.

Step 7

Execute the following command. Refer Fig 2.1.

C:\install\SQLServer2005SP1-KB913090-x86-ENU.exe /allinstances /quiet

If you are using a network share then type the following command:

\\fileserver\shareddrive\SQLServer2005SP1-KB913090-XXX-LLL.exe /quiet

Note: Update the name of the fileserver with your actual fileserver name and update the shared drive name accordingly.

If you open the task manager, you can see the following executable running as a windows task. Refer Fig 2.2.

In addition, you could see the hotfix.log file is being written under c:\windows\hotfix. Refer Fig 2.3 and Fig 2.4.

Note: c:\windows is the default Windows directory. If your default is not C:\windows then navigate to the right Windows folder and underneath you will find the hotfix folder.

Step 8

Now connect to database service instance, JANE, and Analysis service instance, JANE, using SQL Server Management Studio. You can see the following connections on the object browser. Refer Fig 1.0.

Please notice the version number of both Database Service and Analysis service that you are connected to: 9.00.2047 and 9.00.2047.00.

Open SQL Server Management Studio and connect to the database engine instance you want to patch. Right click on the server and click on properties. If you have RTM version, it will display the following message. Refer Fig 2.6.

Please notice the version number of the Database Service instance that you are connected to is 9.00.2047.

You can also see that it upgraded the client components as well. Refer Fig 2.7.

Conclusion

SQL Server 2005 Service packs can be installed using setup.exe parameters at the Windows command prompt. In this section of this series, you have learned how to install SQL server 2005 Service Pack 1 to update the server components using command line options.

» See All Articles by Columnist MAK