Originally posted by amesjustin
I don't think I follow what you are asking. You are trying to change DB access on a SQL Authenicated user, and it is asking you to change the password, too?
Are you sure it is not just asking for the password to confirm that you have the rights to change the database access?
1. Go into Enterprise Manager
2. Select security/logins
3. Go to a sql auth. user that has already been setup
4. Go to the tab Database Access
5. Add them to another database with any permissions
6. Click OK
After clicking ok, I'm prompted to confirm their password.
Originally posted by Satya
Not at my end too, what is the privilege for this user on SQL server?
I'm connecting to Enterprise Manager with a user that has system administrator. The privilege for the existing sql user (janet) has public/db_datareader on one database (RECON) and I'm trying to add them to the an new database (ALCO) with the same privileges.