SQL Server Performance

sqlserver service pack for service pack 2

Discussion in 'SQL Server 2005 General DBA Questions' started by priyaram, Mar 16, 2007.

  1. priyaram New Member

    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,
  2. khtan New Member

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


    KH
  3. priyaram New Member

    is there any link to the latest release of SP2 after applying all the fixes?
  4. khtan New Member

  5. priyaram New Member

    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,
  6. khtan New Member

  7. madhuottapalam New Member

  8. priyaram New Member

    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
  9. MohammedU New Member

  10. priyaram New Member

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

    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
  12. priyaram New Member

    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:program 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
  13. MohammedU New Member

    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
  14. priyaram New Member

    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
  15. MohammedU New Member

  16. priyaram New Member

    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
  17. priyaram New Member

    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
  18. MohammedU New Member

    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
  19. priyaram New Member

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

    thanks
  20. MohammedU New Member

    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
  21. priyaram New Member

    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
  22. MohammedU New Member

    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

Share This Page