Showing posts with label apply. Show all posts
Showing posts with label apply. Show all posts

Tuesday, March 20, 2012

Patching WMSDE with SP4

Can anyone tell me whether WMSDE (which installs with WSUS) can be patched?
I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
message stating that SQL server is not installed.
Thanks in advance for your help.
Hi
You may want to print the exact error message, but any instance of SQL
Server should be patchable with the correct patch file.
John
"Buckeye" <Buckeye@.discussions.microsoft.com> wrote in message
news:94A93D9E-A8A8-481F-B1D8-12C9EA0E79E7@.microsoft.com...
> Can anyone tell me whether WMSDE (which installs with WSUS) can be
> patched?
> I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
> message stating that SQL server is not installed.
> Thanks in advance for your help.

Patching WMSDE with SP4

Can anyone tell me whether WMSDE (which installs with WSUS) can be patched?
I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
message stating that SQL server is not installed.
Thanks in advance for your help.Hi
You may want to print the exact error message, but any instance of SQL
Server should be patchable with the correct patch file.
John
"Buckeye" <Buckeye@.discussions.microsoft.com> wrote in message
news:94A93D9E-A8A8-481F-B1D8-12C9EA0E79E7@.microsoft.com...
> Can anyone tell me whether WMSDE (which installs with WSUS) can be
> patched?
> I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
> message stating that SQL server is not installed.
> Thanks in advance for your help.

Patching WMSDE with SP4

Can anyone tell me whether WMSDE (which installs with WSUS) can be patched?
I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
message stating that SQL server is not installed.
Thanks in advance for your help.Hi
You may want to print the exact error message, but any instance of SQL
Server should be patchable with the correct patch file.
John
"Buckeye" <Buckeye@.discussions.microsoft.com> wrote in message
news:94A93D9E-A8A8-481F-B1D8-12C9EA0E79E7@.microsoft.com...
> Can anyone tell me whether WMSDE (which installs with WSUS) can be
> patched?
> I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
> message stating that SQL server is not installed.
> Thanks in advance for your help.

Patches and updates

Newbie question:
Does SQL Server 2000 have an updates service like that for
Windows that tells you what you have and what you need to
apply? Is there a comprehensive list of updates and
patches? I've looked thru MS website and I didn't locate
it yet.
Thanks for your time.
DionDion,
Iam not aware about any update service but you can certainly subscribe to
the newsletter.This article provides a exhaustive list of patches and
service packs
SQLSecurity Checklist
http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Dion" <dreihs@.aol.com> wrote in message
news:114f01c37258$681f5c00$a501280a@.phx.gbl...
> Newbie question:
> Does SQL Server 2000 have an updates service like that for
> Windows that tells you what you have and what you need to
> apply? Is there a comprehensive list of updates and
> patches? I've looked thru MS website and I didn't locate
> it yet.
> Thanks for your time.
> Dion|||Thank you for you quick response.
How do you know where to begin? Can you just start at the
latest greatest cumulative patch (Cumulative Patch for
Microsoft SQL Server (815495)) or is there a progression?
Dion
>--Original Message--
>Dion,
>Iam not aware about any update service but you can
certainly subscribe to
>the newsletter.This article provides a exhaustive list of
patches and
>service packs
>SQLSecurity Checklist
>http://www.sqlsecurity.com/DesktopDefault.aspx?
tabindex=3&tabid=4
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Dion" <dreihs@.aol.com> wrote in message
>news:114f01c37258$681f5c00$a501280a@.phx.gbl...
>> Newbie question:
>> Does SQL Server 2000 have an updates service like that
for
>> Windows that tells you what you have and what you need
to
>> apply? Is there a comprehensive list of updates and
>> patches? I've looked thru MS website and I didn't locate
>> it yet.
>> Thanks for your time.
>> Dion
>
>.
>|||Try the following:
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/security/current.asp?
productid=30&servicepackid=0
Choose your product version and service pack level, then
click GO, and you will see a list of all security-related
hotfixes that apply. For instance, right now, the latest
for SQL2K with SP3 is MS03-031, which is a cumulative fix.
--m
>--Original Message--
>Dion,
>Iam not aware about any update service but you can
certainly subscribe to
>the newsletter.This article provides a exhaustive list of
patches and
>service packs
>SQLSecurity Checklist
>http://www.sqlsecurity.com/DesktopDefault.aspx?
tabindex=3&tabid=4
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Dion" <dreihs@.aol.com> wrote in message
>news:114f01c37258$681f5c00$a501280a@.phx.gbl...
>> Newbie question:
>> Does SQL Server 2000 have an updates service like that
for
>> Windows that tells you what you have and what you need
to
>> apply? Is there a comprehensive list of updates and
>> patches? I've looked thru MS website and I didn't locate
>> it yet.
>> Thanks for your time.
>> Dion
>
>.
>|||Dion,
That would be your call.Usually the service packs include all the patches
till then.Any bugs after that, if documented, would be having hotfixes.In
case you experience that, just search in http://support.microsoft.com and
apply the hotfix.If the bug is not documented you can call MS PSS.In any
case, make sure to read the related documentation and test it in a dev
environment before applying them in production.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Dion" <dreihs@.aol.com> wrote in message
news:127401c3725e$2f332880$a601280a@.phx.gbl...
> Thank you for you quick response.
> How do you know where to begin? Can you just start at the
> latest greatest cumulative patch (Cumulative Patch for
> Microsoft SQL Server (815495)) or is there a progression?
> Dion
> >--Original Message--
> >Dion,
> >
> >Iam not aware about any update service but you can
> certainly subscribe to
> >the newsletter.This article provides a exhaustive list of
> patches and
> >service packs
> >
> >SQLSecurity Checklist
> >http://www.sqlsecurity.com/DesktopDefault.aspx?
> tabindex=3&tabid=4
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Dion" <dreihs@.aol.com> wrote in message
> >news:114f01c37258$681f5c00$a501280a@.phx.gbl...
> >> Newbie question:
> >>
> >> Does SQL Server 2000 have an updates service like that
> for
> >> Windows that tells you what you have and what you need
> to
> >> apply? Is there a comprehensive list of updates and
> >> patches? I've looked thru MS website and I didn't locate
> >> it yet.
> >>
> >> Thanks for your time.
> >> Dion
> >
> >
> >.
> >

Monday, March 12, 2012

Patch question re: SQL 7.0 SP4

I'm getting ready to apply SQL 7.0 SP4 and the SQL Server instance is running on Win NT
4.0 SP6. According to http://support.microsoft.com/?id=327068, there is an
O/S patch that needs to be applied, per KB 258437. Fine and well, but then
I see in http:/
/support.microsoft.com/?id=821279 that this patch superseeds (sp?) the previ
ous SQL patch.
So, all that being said, do I still need to apply the O/S patch in KB 258437
? At what point to I apply the patch; before SP4, between SP4 and KB 821279
, or after KB 821279?
Better yet, how do I convince management / users / vendors to upgrade to Win
2K / SQL 2K? ;-)
TIA,
Mike
mstuart_nospam@.gates.comAll,
FYI, I spoke to some folks at Microsoft, and I was told to install SP4 then KB821279 (p
atch available at http://www.microsoft.com/downloads/...&displaylang=en) and that should take care of i
t.
Mike

patch apply question

I got 4 sql2k5 servers with service patch version as following:
Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.
Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.
Hi
You may want to check out
https://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
Post SP2 there are also some additional fixes the last publically available
hotfix is http://support.microsoft.com/?Kbid=934459
You should test your applications to make sure they are still working on the
upgraded version before moving.
John
"-Obama" wrote:

> I got 4 sql2k5 servers with service patch version as following:
> Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Can anyone please advise me what is the easiest way to upgrade them to the
> most updated patch version? i.e. update path.
> Meanwhile, what is the best practice to apply patches? Do you go to
> microsoft website and check it out daily and apply it or other tricks?
> Please advise. Thanks.
>
>

patch apply question

I got 4 sql2k5 servers with service patch version as following:
Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.
Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.Hi
You may want to check out
https://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
Post SP2 there are also some additional fixes the last publically available
hotfix is http://support.microsoft.com/?Kbid=934459
You should test your applications to make sure they are still working on the
upgraded version before moving.
John
"-Obama" wrote:
> I got 4 sql2k5 servers with service patch version as following:
> Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Can anyone please advise me what is the easiest way to upgrade them to the
> most updated patch version? i.e. update path.
> Meanwhile, what is the best practice to apply patches? Do you go to
> microsoft website and check it out daily and apply it or other tricks?
> Please advise. Thanks.
>
>