Re: Security Update for SQL Server 2000 Service Pack 4 (KB948110)
- From: thejamie <thejamie@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 1 Oct 2008 16:32:02 -0700
I'll try to put in an "English" version. There are two different methods to
log into SQL Server. One is the one we are all familiar with - it is related
to our user name and password when we log into our machine (called Windows
Authentication) The other is SQL Authentication where, if the given database
is configured to use this authentication, there exists a superuser who can do
anything on that database server if they have the correct password (SA
Password). Apparently, the 948110 hotfix will not work on a database server
where there is either no sa password given (which is the case for the
SBSMonitoring and MSFW instances on Small Business Server).
What he suggests is to switch the authentication method of the database to
SQL authentication long enough to 1) create an sa password or if none is
available, use an account with sa privilege and 2) provide that privelege to
the BUILTIN\Administrator account and 3) switch authentication from the SQL
mode to the Windows Authentication mode and 4) run the update, and 5) undo
this.
I'm a bit confused because I think that switching to SQL Authentication and
providing JUST a password and running the update is not sufficient but that
this can also work provided the password is strong enough.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=357228
You may be able to infer the fix from the next link although I would agree
with the MVP that you may as well get help directly from Microsoft for this
issue - caveat - your server must be down and causing a work stoppage for
free support otherwise, it may be a pay event. I have also seen that it is
refundable if this issue is Windows Update related. I made a request to the
team to clean up the information on the website below to make it easier to
understand what is needed to fix the issue without making it worse first.
http://support.microsoft.com/kb/948110/
--
Regards,
Jamie
"theloniouscoltrane" wrote:
While I appreciate the work that PsychBiller did in transcribing his fix, he.
could have said in Romanian and it wouldn't have been any more difficult to
understand.
Is there anyone out there who knows the solution and can explain it to
non-geeks.
"PsychBiller" wrote:
I just spent 3 hours on the phone with Microsoft tech support to
resolve this.
- Prev by Date: Re: Internet Explorer 6.0 and Office 2007 Compatibility
- Next by Date: Re: WIndows update error for KB948110
- Previous by thread: Win XP Service Pack 3 install errors
- Next by thread: Re: WIndows update error for KB948110
- Index(es):
Relevant Pages
|
