December 20, 2005 at 2:02 pm
I had the need to recover my databases on a different server (DR Drill)
The Server has a different name than the production server where these databases normally live.
What I did was script out the logins using sp_help_revlogin on the source server and then ran the script on the destination server.
I then restored all of my user databases to the destination server from a recent backup. After the restores, All of the logins look fine permissions-wise and all of the passwords work too!! but.. when I go into security via EM and look at any of the logins to double-check permissions, I get a dialog box wanting me to 'confirm' the password change and I can't OK so I have to cancel out. all of the logins are behaving this way - even 'sa' - but they all work fine... any ideas???????
December 20, 2005 at 2:13 pm
This is a known bug that happens after MS03-031. A hotfix is available here.
FIX: You are prompted for password confirmation after you change a standard SQL Server login
K. Brian Kelley
@kbriankelley
December 20, 2005 at 2:23 pm
Thanks!! I searched MS but didn't find this. thanks Brian!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply