Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
Is Express not maintained through windows update? –  TomTom Mar 14 '12 at 8:40

1 Answer 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.