Home / server / Questions / 369495
In Process
FrinkTheBrave
Asked: 2012-03-15 00:26:20 +0800 CST

Automate install of SQL Server 2005 Express Service Packs

  • 772

Is it possible to perform an unnattended install of service packs (SP4 is the latest) on SQL Server 2005 Express?

The only way I have found is to download the SQLEXPR32.EXE containing SP4 and run it manually for each of my instances which need it. This takes ages, but I can't get any of the command line options to work.

I do have a SQL Server 2005 (not Express) instance on the server as well, but I can download and apply the service pack to this without a problem. Is it a restriction of Express?

Any ideas?

UPDATE: It has no internet connectivity so I have to do it manually

sql-server-2005 windows-server-2003 automated-install service-pack

1 Answers

  1. If you enable Microsoft Updates on Windows Updates form it will look for all Microsoft products installed on your server, such as SQL Server. Then, using the automatic download and install settings you'll have SPs installed automatically.

    • 0