You should provide the password for the new user.
This article may help with the error message:
http://support.microsoft.com/default.aspx?kbid=826161
Hope this helps.
Tim
>--Original Message--
>I have added a new User Login in Enterprise Manager. I
>then want to give that User access to a database. When I
>tick the appropriate table in the the Database Access
>property of the User, I am prompted to confirm the
>password.
>Which password is the system expecting here? The user's
>password or the SA passsord? But no matter what I type,
I
>get a message: "The confirmation password is not correct"
>
>
>
>.
>Newbie? I don't think so. This has always bugged the heck out of me. Thanks
for asking!
And, even if it is NOT a new user, when you want to add a database from the
Server Security folder, just be sure to reenter the users password before yo
u hit the "permissions" tab. Then, when you add the database access you desi
re, the prompt for the new
password will accept the password.
David
Showing posts with label article. Show all posts
Showing posts with label article. Show all posts
Subscribe to:
Posts (Atom)