SQL Server 2005 SP1 is now generally available for download via the web at: http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en.

Additionally, a number of Knowledge Base articles could be useful: