add user to database role

Hello,
When i add a user to a database role, enterprise manager
ask me for the user password. I do the same in other
server and and i don't need to give any password.
I've yet the same problem but i cant remember what i've
done to correct this situation.
Best RegardsHi;
Not sure about this issue. I recommend you to add the server / database
fixed roles
from query analyzer.
For the Server wide roles use :-
sp_addsrvrolemember 'login','sysadmin'
For the Database wide roles use:-
use paytest
go
sp_addrolemember 'db_owner','user'
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18df601c44c75$c16bd250$a301280a@.phx.gbl...
> Hello,
> When i add a user to a database role, enterprise manager
> ask me for the user password. I do the same in other
> server and and i don't need to give any password.
> I've yet the same problem but i cant remember what i've
> done to correct this situation.
> Best Regards|||You may be running into the following:
FIX: You Are Prompted for Password Confirmation After You
Change a Standard SQL Server Login
http://support.microsoft.com/?id=826161
-Sue
On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:
>Hello,
>When i add a user to a database role, enterprise manager
>ask me for the user password. I do the same in other
>server and and i don't need to give any password.
>I've yet the same problem but i cant remember what i've
>done to correct this situation.
>Best Regards|||Thanks Sue
I apply the patch and now i've got no problem
Thanks again,
bye
>--Original Message--
>You may be running into the following:
>FIX: You Are Prompted for Password Confirmation After You
>Change a Standard SQL Server Login
>http://support.microsoft.com/?id=826161
>-Sue
>On Mon, 7 Jun 2004 02:56:51 -0700, "CC&JM"
><anonymous@.discussions.microsoft.com> wrote:
>>Hello,
>>When i add a user to a database role, enterprise manager
>>ask me for the user password. I do the same in other
>>server and and i don't need to give any password.
>>I've yet the same problem but i cant remember what i've
>>done to correct this situation.
>>Best Regards
>.
>