Hi,
All of sudden, all my SQL 2K servers start to ask "Confirm
new password" when I assign a database access permission
to a local user. Even though I type in the correct
password, it still say "The confirmation password is not
correct". Right now I simply cannot assign any database
access to the local users. But the domain trusted users
don't have this problem. Does anyone know what the problem
is?
Thank you in advance for your help.
David...I'm trying to remember back - I had this occur ages ago. Have you either
service packed the server or switched client workstation? I "think" it was
fixed by service packing my client machine (to get it inline with the server
).
Alicia
Http://www.sqlporn.co.uk|||I applied SQL 2K security patch about a month ago, and
brought the builder version to 8.00.818. I just found the
article that addresses this problem.
http://support.microsoft.com/default.aspx?kbid=826161
Thanks for your information.
David.
>--Original Message--
>...I'm trying to remember back - I had this occur ages
ago. Have you either service packed the server or switched
client workstation? I "think" it was fixed by service
packing my client machine (to get it inline with the
server).
>Alicia
>Http://www.sqlporn.co.uk
>.
>|||This was a bug with the security rollup for SQL. You need to install build
819.
826161 FIX: You Are Prompted for Password Confirmation After You Change a
http://support.microsoft.com/?id=826161
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
I downloaded and applied the hotfix. The problem is gone.
But when I check the SQL server product version that is
still showing 8.00.818(SP3). Is that right? I thought it
should show the version # 8.00.819(SP3). Is there
something that I didn't do right?
Thank you for your help.
David.
>--Original Message--
>This was a bug with the security rollup for SQL. You
need to install build
>819.
>826161 FIX: You Are Prompted for Password Confirmation
After You Change a
>http://support.microsoft.com/?id=826161
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||to dive in, the hotfix just changes a DLL (can't remember which) and doesn't
affect sqlservr.exe so therefore you still see 818. This is expected
behaviour
regards,
Andy.
"David W." <anonymous@.discussions.microsoft.com> wrote in message
news:17d6101c44992$2faee360$a501280a@.phx
.gbl...[vbcol=seagreen]
> Hi Kevin,
> I downloaded and applied the hotfix. The problem is gone.
> But when I check the SQL server product version that is
> still showing 8.00.818(SP3). Is that right? I thought it
> should show the version # 8.00.819(SP3). Is there
> something that I didn't do right?
> Thank you for your help.
> David.
> need to install build
> After You Change a
> confers no rights.|||Hi David,
Sorry. That is correct. SQL Server .exe is still 818.
01-Jun-2003 01:02 2000.80.818.0 7,544,916 bytes Sqlservr.exe
This is the only component stamped 819.
01-Jun-2003 01:01 2000.80.819.0 492,096 bytes Semobj.dll
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
No comments:
Post a Comment