SQL Server Performance Forum – Threads Archive

sqlserver service pack for service pack 2

yestarday there is an article released about the service pack for the service pack 2 for sqlserver wo downloaded before mar 5 , 2007. but to my development server i didn’t download sp2 yet. Ifs it safe to download the sp2 for sqlserver 2005 enterprise edition now?? thanks,

Yes. I have applied SP2 on my servers. So far so good.
KH

is there any link to the latest release of SP2 after applying all the fixes?

this is the hotfix.
http://www.microsoft.com/downloads/…a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en
KH

The link listed above is the hot fix for the already installed sp2. I didn’t install before.
today only i am going to install sp2 for for sqlserver 2005 on 64 bit in windows 2003 server.
so i am ckecking any direct link for sp2 with al the fixes applied
It’s for first time install of sp2 thanks,

then get the SP2 herehttp://www.microsoft.com/downloads/…B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en
KH

refer this link :http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19624 Madhu

Microsoft SQL Server 2005 – 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) My server reports the above result when i executed select @@version after applying the service pack 2. Is this right?? Thanks

I believe 3042 is SP2 without hotfix…
with hotfix it is 3152…. http://support.microsoft.com/kb/933097
MohammedU.
Moderator
SQL-Server-Performance.com

does any body have any idea why after the installation of the sp2 , my version still shows sp1.
i am really confused

In your post you mentoined that your server reports build number 3042 which is SP2…
Now you are saying your server reports SP1… Where do you see this SP1??? Try running the following to see what SP you are on…
select serverproperty(‘ProductLevel’)
MohammedU.
Moderator
SQL-Server-Performance.com

hi mohammed, if i run your statement it gives " SP2" but when i run select @@version now, the output is " Microsoft SQL Server 2005 – 9.00.3152.00 (X64) Mar 3 2007 05:22:48 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) " and also i applied the hotfix that you specified " KB 933097 X64" file.
my version now says above. but while installing all other got success while only 1 failed with the below reason, Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB933097_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object ‘dm_exec_query_resource_semaphores’, because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
why this is coming?? thanks

May be some installation failures…. Try running the repair against SQL SERVER SUPPORT SETUP SUPPORT FILES through ADD/REMOVE PROGRAMS and then reinstall SP2.
Download SP2 again which has patch included in it. MohammedU.
Moderator
SQL-Server-Performance.com

is it possible we can uninstall sp2 with out effecting sqlserver 2005 is there any link which is having the sp2 with patch
because i tried to search ,but i didn’t get one

You can’t uninstall in any easy way without uninstalling sql server… Once SQL Server 2005 SP2 has been applied, it cannot be removed without uninstalling the entire product… Microsoft SQL Server 2005 Service Pack 2
http://www.microsoft.com/downloads/…FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A
MohammedU.
Moderator
SQL-Server-Performance.com

hi mohammed that’s the service pack i installed for the first time.
after that i installed the hotfit that you specified in the link before.
what shall i do now…
please help me out… is there a way to uninstall the hotfix alone , without effecting service pack 2 and sqlserver?? or else we can leave this error as it’s… it’s my new job and first task…. please help me out thanks

You can’t uninstall hotfix or sevice pack at all.
Did you try what I mentioned before… "
Try running the repair against SQL SERVER SUPPORT SETUP SUPPORT FILES through ADD/REMOVE PROGRAMS and then reinstall SP2.
Download SP2 again which has patch included in it.
" OR
Best way is to contact Microsoft PSS. MohammedU.
Moderator
SQL-Server-Performance.com

while installing sp2 , we have to chose windows or sqlserver authentication?? thanks

Either one should be fine but I prefer to choose WINDOWS authentication and make sure the login is member of local aministrators group. MohammedU.
Moderator
SQL-Server-Performance.com

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A
once we install the sp2 from the above link, did we need hotfix also to be applied or no.. is there anyother stuff we need to install after the above sp2 install

No…
If you downloaded before March 5th you need to apply the fix otherwise it is included… See the following article…
http://support.microsoft.com/kb/933508
MohammedU.
Moderator
SQL-Server-Performance.com

]]>