When in Enterprise Manager on my PC, in the 'SQL Server Login Properties' box, I go to the Database Access tab and try to add a role for a user. When I do, I get a 'Confirm Password' box! If I give it the password for the login I'm trying to change, or if I use the 'sa' password, I get 'The confirmation password is not correct'. The server is registered in EM with the sa login. This happens on multiple servers (7.0 and 2000)and multiple logins.
I have not seen this behavior before - is it intentional? I recently ran the MDAC patch (MS03-033) on my PC, I wonder if that could have caused it? Thanks in advance for any information,
LarryD