password issue assigning role to login

i am running into a strange thing...at least to me
in enterprise mgr-security-logins
i double click the user, go to the server roles tab and then check the role
i want to add to that user
when i click okay, it prompts me for a confirmation password..that seems odd
to me
i am not certain what password its looking for so i have
entered my AD password, and the SA password, and this logins
password..doesn't matter everytime it tells me the password is incorrect
anyone know what is going on?I am running into a strange thing...at least to
me
in enterprise mgr-security-logins
I double click the user, go to the server roles tab and then check the role
I want to add to that user
when I click okay, it prompts me for a confirmation password..that seems odd
to me
I am not certain what password its looking for so I have
entered my AD password, and the SA password, and this logins
password..doesn't matter every time it tells me the password is incorrect
anyone know what is going on?What version of SQL server and service pack you are running?
--
Thanks & Rate the Postings.
-Ravi-
"jason" wrote:
> i am running into a strange thing...at least to me
> in enterprise mgr-security-logins
> i double click the user, go to the server roles tab and then check the role
> i want to add to that user
> when i click okay, it prompts me for a confirmation password..that seems odd
> to me
> i am not certain what password its looking for so i have
> entered my AD password, and the SA password, and this logins
> password..doesn't matter everytime it tells me the password is incorrect
> anyone know what is going on?I am running into a strange thing...at least to
> me
> in enterprise mgr-security-logins
> I double click the user, go to the server roles tab and then check the role
> I want to add to that user
> when I click okay, it prompts me for a confirmation password..that seems odd
> to me
> I am not certain what password its looking for so I have
> entered my AD password, and the SA password, and this logins
> password..doesn't matter every time it tells me the password is incorrect
> anyone know what is going on?|||2000
sp3a
ms03031
on a cluster
"Ravi" wrote:
> What version of SQL server and service pack you are running?
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "jason" wrote:
> > i am running into a strange thing...at least to me
> >
> > in enterprise mgr-security-logins
> > i double click the user, go to the server roles tab and then check the role
> > i want to add to that user
> >
> > when i click okay, it prompts me for a confirmation password..that seems odd
> > to me
> > i am not certain what password its looking for so i have
> > entered my AD password, and the SA password, and this logins
> > password..doesn't matter everytime it tells me the password is incorrect
> >
> > anyone know what is going on?I am running into a strange thing...at least to
> > me
> >
> > in enterprise mgr-security-logins
> > I double click the user, go to the server roles tab and then check the role
> > I want to add to that user
> >
> > when I click okay, it prompts me for a confirmation password..that seems odd
> > to me
> > I am not certain what password its looking for so I have
> > entered my AD password, and the SA password, and this logins
> > password..doesn't matter every time it tells me the password is incorrect
> >
> > anyone know what is going on?|||This is becuase of the security patch MS03-031 you installed on the server.
Every time you change the property of the login account you have to enter the
password (Password of the login account) and confirm the password.
Workaroung to avoid this is, use the system stored procedures to modify the
login accounts
E.g
use the stored procedure sp_addsrvrolemember to add a login to the server
role.
Thanks & Rate the Postings.
-Ravi-
"jason" wrote:
> 2000
> sp3a
> ms03031
> on a cluster
> "Ravi" wrote:
> > What version of SQL server and service pack you are running?
> > --
> > Thanks & Rate the Postings.
> > -Ravi-
> >
> >
> > "jason" wrote:
> >
> > > i am running into a strange thing...at least to me
> > >
> > > in enterprise mgr-security-logins
> > > i double click the user, go to the server roles tab and then check the role
> > > i want to add to that user
> > >
> > > when i click okay, it prompts me for a confirmation password..that seems odd
> > > to me
> > > i am not certain what password its looking for so i have
> > > entered my AD password, and the SA password, and this logins
> > > password..doesn't matter everytime it tells me the password is incorrect
> > >
> > > anyone know what is going on?I am running into a strange thing...at least to
> > > me
> > >
> > > in enterprise mgr-security-logins
> > > I double click the user, go to the server roles tab and then check the role
> > > I want to add to that user
> > >
> > > when I click okay, it prompts me for a confirmation password..that seems odd
> > > to me
> > > I am not certain what password its looking for so I have
> > > entered my AD password, and the SA password, and this logins
> > > password..doesn't matter every time it tells me the password is incorrect
> > >
> > > anyone know what is going on?|||i entered that password and it still didn't do it
and i doubled checked that i was entering it correctly
is this something that was fixed with sp4?
"Ravi" wrote:
> This is becuase of the security patch MS03-031 you installed on the server.
> Every time you change the property of the login account you have to enter the
> password (Password of the login account) and confirm the password.
> Workaroung to avoid this is, use the system stored procedures to modify the
> login accounts
> E.g
> use the stored procedure sp_addsrvrolemember to add a login to the server
> role.
>
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "jason" wrote:
> > 2000
> > sp3a
> > ms03031
> >
> > on a cluster
> >
> > "Ravi" wrote:
> >
> > > What version of SQL server and service pack you are running?
> > > --
> > > Thanks & Rate the Postings.
> > > -Ravi-
> > >
> > >
> > > "jason" wrote:
> > >
> > > > i am running into a strange thing...at least to me
> > > >
> > > > in enterprise mgr-security-logins
> > > > i double click the user, go to the server roles tab and then check the role
> > > > i want to add to that user
> > > >
> > > > when i click okay, it prompts me for a confirmation password..that seems odd
> > > > to me
> > > > i am not certain what password its looking for so i have
> > > > entered my AD password, and the SA password, and this logins
> > > > password..doesn't matter everytime it tells me the password is incorrect
> > > >
> > > > anyone know what is going on?I am running into a strange thing...at least to
> > > > me
> > > >
> > > > in enterprise mgr-security-logins
> > > > I double click the user, go to the server roles tab and then check the role
> > > > I want to add to that user
> > > >
> > > > when I click okay, it prompts me for a confirmation password..that seems odd
> > > > to me
> > > > I am not certain what password its looking for so I have
> > > > entered my AD password, and the SA password, and this logins
> > > > password..doesn't matter every time it tells me the password is incorrect
> > > >
> > > > anyone know what is going on?|||Did you enter the password in the first tab?
--
Thanks & Rate the Postings.
-Ravi-
"jason" wrote:
> i entered that password and it still didn't do it
> and i doubled checked that i was entering it correctly
> is this something that was fixed with sp4?
> "Ravi" wrote:
> > This is becuase of the security patch MS03-031 you installed on the server.
> > Every time you change the property of the login account you have to enter the
> > password (Password of the login account) and confirm the password.
> >
> > Workaroung to avoid this is, use the system stored procedures to modify the
> > login accounts
> > E.g
> > use the stored procedure sp_addsrvrolemember to add a login to the server
> > role.
> >
> >
> > --
> > Thanks & Rate the Postings.
> > -Ravi-
> >
> >
> > "jason" wrote:
> >
> > > 2000
> > > sp3a
> > > ms03031
> > >
> > > on a cluster
> > >
> > > "Ravi" wrote:
> > >
> > > > What version of SQL server and service pack you are running?
> > > > --
> > > > Thanks & Rate the Postings.
> > > > -Ravi-
> > > >
> > > >
> > > > "jason" wrote:
> > > >
> > > > > i am running into a strange thing...at least to me
> > > > >
> > > > > in enterprise mgr-security-logins
> > > > > i double click the user, go to the server roles tab and then check the role
> > > > > i want to add to that user
> > > > >
> > > > > when i click okay, it prompts me for a confirmation password..that seems odd
> > > > > to me
> > > > > i am not certain what password its looking for so i have
> > > > > entered my AD password, and the SA password, and this logins
> > > > > password..doesn't matter everytime it tells me the password is incorrect
> > > > >
> > > > > anyone know what is going on?I am running into a strange thing...at least to
> > > > > me
> > > > >
> > > > > in enterprise mgr-security-logins
> > > > > I double click the user, go to the server roles tab and then check the role
> > > > > I want to add to that user
> > > > >
> > > > > when I click okay, it prompts me for a confirmation password..that seems odd
> > > > > to me
> > > > > I am not certain what password its looking for so I have
> > > > > entered my AD password, and the SA password, and this logins
> > > > > password..doesn't matter every time it tells me the password is incorrect
> > > > >
> > > > > anyone know what is going on?|||that "fixed" it with my test account where i knew the password
but i am not going to know peoples password when i add some security to
their login
i guess i will have to use the workaround till this bug is fixed.
thanks for bringing some clarity to this issue
"Ravi" wrote:
> Did you enter the password in the first tab?
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "jason" wrote:
> > i entered that password and it still didn't do it
> > and i doubled checked that i was entering it correctly
> >
> > is this something that was fixed with sp4?
> >
> > "Ravi" wrote:
> >
> > > This is becuase of the security patch MS03-031 you installed on the server.
> > > Every time you change the property of the login account you have to enter the
> > > password (Password of the login account) and confirm the password.
> > >
> > > Workaroung to avoid this is, use the system stored procedures to modify the
> > > login accounts
> > > E.g
> > > use the stored procedure sp_addsrvrolemember to add a login to the server
> > > role.
> > >
> > >
> > > --
> > > Thanks & Rate the Postings.
> > > -Ravi-
> > >
> > >
> > > "jason" wrote:
> > >
> > > > 2000
> > > > sp3a
> > > > ms03031
> > > >
> > > > on a cluster
> > > >
> > > > "Ravi" wrote:
> > > >
> > > > > What version of SQL server and service pack you are running?
> > > > > --
> > > > > Thanks & Rate the Postings.
> > > > > -Ravi-
> > > > >
> > > > >
> > > > > "jason" wrote:
> > > > >
> > > > > > i am running into a strange thing...at least to me
> > > > > >
> > > > > > in enterprise mgr-security-logins
> > > > > > i double click the user, go to the server roles tab and then check the role
> > > > > > i want to add to that user
> > > > > >
> > > > > > when i click okay, it prompts me for a confirmation password..that seems odd
> > > > > > to me
> > > > > > i am not certain what password its looking for so i have
> > > > > > entered my AD password, and the SA password, and this logins
> > > > > > password..doesn't matter everytime it tells me the password is incorrect
> > > > > >
> > > > > > anyone know what is going on?I am running into a strange thing...at least to
> > > > > > me
> > > > > >
> > > > > > in enterprise mgr-security-logins
> > > > > > I double click the user, go to the server roles tab and then check the role
> > > > > > I want to add to that user
> > > > > >
> > > > > > when I click okay, it prompts me for a confirmation password..that seems odd
> > > > > > to me
> > > > > > I am not certain what password its looking for so I have
> > > > > > entered my AD password, and the SA password, and this logins
> > > > > > password..doesn't matter every time it tells me the password is incorrect
> > > > > >
> > > > > > anyone know what is going on?