Post reply

service pack issue

  • November 4, 2004 at 8:45 am

    #86804

    Hi ,

     

    i installed service pack 3a but still i am getting 8.00.194 version ,i checked logs also there is no error ,even service pack installed successfully .

    Any Clue?

    Thanks,

    sq

  • November 4, 2004 at 8:56 am

    #528932

    Are you sure you updated the correct instance? If you're running multiple instances, you do have to run the update on each instance separately. If you're not running multiple instances, I'm not sure -- try re-applying the Service Pack...

    --
    Adam Machanic
    whoisactive

  • November 4, 2004 at 8:57 am

    #528933

    Also, I just found this KB article that might apply:

    http://support.microsoft.com/?id=312995

    --
    Adam Machanic
    whoisactive

  • November 4, 2004 at 9:00 am

    #528935

    no i have only one instance and i have re-applied thrice.

    and i downloaded from

    http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en

    Thanks for your reply.

  • November 5, 2004 at 2:55 am

    #529064

    How are you obtaining this number?

    Reason being, if you get it from the registry then there are a couple of places to look.

    This location gives the original version:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

    Where this version contains the newest 'hotfix' which is what you're probably explecting to see:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\HotFixes

     

    If you just do 'xp_msver ProductVersion' then that should be correct...

  • November 5, 2004 at 4:12 am

    #529068

    yes i did with xp_msver productversion.

    Thanks

     

  • November 5, 2004 at 7:35 am

    #529091

    Is this MSDE?  I had the same issue with a vendor installed MSDE instance when I attempted to load SP3a.  Investigation revealed that they had not set an 'sa' password which caused the upgrade to fail.  I had the same symptoms as you - installation would complete, show no errors, but the version reported was still wrong.  If you don't have an 'sa' password, either set one (strongly reccomended) or run:

    'setup.exe /updatesp runsql blanksapwd=1'
     
    from a command prompt and see if this helps.  Best of luck. 
     
     

    My hovercraft is full of eels.

  • November 6, 2004 at 5:49 am

    #529186

    hey man thanx alot for your reply ,but it did not work for me

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply