SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2000 Security Fix KB948110


SQL 2000 Security Fix KB948110

Author
Message
maes.john
maes.john
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 2
When I try to install the new security fix (KB948110) I'm getting one or more sql server instances could not verify your account information. I've tried using NT authentication and using my 'SA" account and I get the same from both. I have used the sa account in query analyzer so I know the password is good. Any help would be great. Thanks John
Leeland
Leeland
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2074 Visits: 1331
getting the same exact senario
GilaMonster
GilaMonster
SSC Guru
SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)

Group: General Forum Members
Points: 224919 Visits: 46321
A quick guess - have you removed Builtin\Administrators from the allowed logins? If so, put it back, make it sysadmin and try the patch again.

No promises. That security patch breaks in a thousand ways and has twice as many fixes.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Leeland
Leeland
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2074 Visits: 1331
GilaMonster (7/31/2008)
A quick guess - have you removed Builtin\Administrators from the allowed logins? If so, put it back, make it sysadmin and try the patch again.

No promises. That security patch breaks in a thousand ways and has twice as many fixes.


Hi Gila,

Well here is the funny thing...I haven't removed anything on this particular server...the BuiltIn\Administrators is still present...

And I had read a lot of posts regarding that very question.

At first I didn't give it much thought and attempted to re-run the patch...it failed.

I know the sa account for the server so I decided to download the patch and attempt to install manually.

When I ran the patch and it asks for verification (Windows vs. SQL)

I entered the sa password I know works as I tested it in Q.A. and it gives an error saying something like "one or more instances cannot verify your account..."

SO...it basically only allows for Windows auth...

The account that I logged into the server initally wasn't set up as a sysadmin so I logged out and relogged in with the account that is running the services which IS a sysadmin on the server...

Re-ran the patch, and used Windows Auth...

Gets to the point in the patch execution where it says "spawning instances" and it hangs and does nothing, no progress...

Then fails with some cryptic error message and requires a reboot...

For this particular server I am on MSSQL 2000 - 8.00.2039
Kathy.Huang
Kathy.Huang
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 79
I got 'one or more server instances could not verify your account information' when I tried to install the new fix (KB948111) couple days ago. I chose SQL Server Authentication (actually we use mixed mode authentication) and provided the right password for SA since I just changed sa password and tested it on osql successfully.

I'm still troubleshooting how to fix this problem to make this new fix installation finish smoothly. Anyone can help?
Kathy.Huang
Kathy.Huang
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 79
continue from previous post regarding 'one or more SQL Server instances could not verify your account'..

Btw, my Builtln\Administrators is still present...

Should I try to install as Window Authentication although we actually use Mixed mode Authentication ? Will it reject SQL Server logins if I install KB948111 as Window Authentication?

Thanks in advance if someone can help!

Kathy
Mr. SQL Guy
Mr. SQL Guy
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 121
Hey all,

I know this is an old topic, but I just spent several hours solving this exact problem. I discovered that the Client Network Utility for SQL Server had incorrect aliases set up for it; deleting them fixed it for me. I'm using SQL Server 2000 SP4, and the particular patch for me was KB960082.

Here's what I did to fix it:

1. On your SQL Server, open up the Client Network Utility (Start-->Programs-->Microsoft SQL Server-->Client Network Utility)
2. Click the "Alias" tab.
3. If you have any aliases defined, delete them.

Hopefully someone else will find this to be useful.

--Mr. SQL Guy
Brian-1079680
Brian-1079680
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 1
I'm having the same issue for KB960083. I checked the client network utility and I did not have any alias' listed. So if anyone has any other helpful ideas as to how to bypass the common error we're having, please share! Smile Thanks!
Mr. SQL Guy
Mr. SQL Guy
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 121
Well, after reading this thread it looks like you also need to make sure that the "BUILTIN\Administrators" group has a login to SQL Server and make sure it is included in the sysadmin role. I guess this assumes you need to configure your SQL Server for mixed authentication mode.

I double checked both SQL Server network utilities and this is the way mine are set up:

SQL Server Client Network Utility:
--Enabled protocols: TCP/IP, Named Pipes (in that order)
--Alias tab: (none defined)

SQL Server Network Utility:
Enabled protocols: Named Pipes, TCP/IP

--Mr. SQL Guy
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search