Is this the sp4 for sql 2005 exp Adv?

Hi, I'm using windows 2008 enterprise server.  I just installed  sql 2005 exp Adv and I need to install sp now for it.  At this site,
Is the file, SQLEXPR_ADV.EXE, a service pack for  sql 2005 exp Adv that I should download and install?  Thanks.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Asim NazirCommented:

That link is to download SqlExpress. To download Service pack, visit

Asim NazirCommented:
Here are more details to choose which file is appropriate for you:

The 32-bit version of SP4 can be used to update 32-bit instances that run in Windows-on-Windows 64 (WOW64) x86 emulation mode on a 64-bit system. The 32-bit version will not upgrade any components of a 64-bit instance of SQL Server 2005. To upgrade all components of a 64-bit instance of SQL Server 2005, use the 64-bit version of SP4.
SP4 packages Operating systems*  
 All supported 32-bit Windows operating systems, including 32-bit instances on 64-bit operating systems.
 Supported Windows Server 2003 and Windows Server 2008 64-bit X64 editions.
 Supported Windows Server 2003 and Windows Server 2008 64-bit Itanium editions.
Details at

I hope it works.
lapuccaAuthor Commented:
Hi, Thank you for the detail.  I'm using windows 2008 server.  I downloaded and install my sql exp advance here,
1.  Should I download this version,  x64
 Supported Windows Server 2003 and Windows Server 2008 64-bit X64 editions.?
2.  These service packs, would they also work for sql 2005 exp Adv?  They're not just for reg sql 2005 version, are they?
Thank you.
Asim NazirCommented:
On point 1, Is it 64 bit version of Windows server 2008? If yes then you need to download and install x64 version of SQL else x86.
On point 2, yes service pack will work - as it's not x64 or x86 specific.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lapuccaAuthor Commented:
Thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.