Tuesday, March 20, 2012

Change database Access - (newbie question)

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

No comments:

Post a Comment