SQL Server Performance Forum – Threads Archive
sp2 for ss005
i am running sqlserver 2005 (x64) in windows 2003 server(x64)do we need to install sp2 for sqlserver,(it’s going to be the prodution server) [purple]System Requirements
Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2
32-bit systems (x86)
PC with Intel or compatible Pentium III 600 MHz or higher processor (1 GHz or faster recommended)
64-bit systems (x64, ia64)
1GHz or faster processor
Minimum of 512 MB of RAM (1 GB or more recommended)
675 MB of available hard disk space
Note: SQL Server 2005 Service Pack 2 (SP2) is designed to run on Windows Vista and Windows Server "Longhorn." For more information about installing and running SQL Server 2005 on Windows Vista and Windows Server "Longhorn," see this Microsoft Web site.[/purple]
i am confused
Hi,
I don’t have faced any problem installing SP2 on 2k5 box
Where did you read this :
/*
Note: SQL Server 2005 Service Pack 2 (SP2) is designed to run on Windows Vista and Windows Server "Longhorn." For more information about installing and running SQL Server 2005 on Windows Vista and Windows Server "Longhorn," see this Microsoft Web site
*/ Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
here it’s:
http://www.microsoft.com/downloads/…b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
I installed SP2 without any problems on WINDOWS 2003 64bit…and may more people did this… Looks like you did not read the sentence completely…
Read again…those who want to install on Vista and Longhorn check the MS site the link provided…… See the following comment from the link you posted…
Note: SQL Server 2005 Service Pack 2 (SP2) is designed to run on Windows Vista and Windows Server "Longhorn." For more information about installing and running SQL Server 2005 on Windows Vista and Windows Server "Longhorn," see this Microsoft Web site. MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I think now your doubt is clear now!!! Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
As referred by Mohammed it is nothing but if you want to install on Vista & Longhorn review the additional information.
As this is going to be production server, ensure you have tested the SP2 implications on your applications. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
also keep in mind to also apply the latest cumulative hotfix http://support.microsoft.com/kb/934459) Elaborated a bit athttp://blogs.msdn.com/psssql/archiv…-2005-service-pack-2-sp2-fixes-explained.aspx
alzdba, Thanks for the latest patch info…
I have included in Forum announcements…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>