Re: setup a sql login which can only reset password


My thinking is that you might have to specify the old password when changing password, if you have ALTER ANY LOGIN permissions. I just want to confirm whether this is the case and if you see that same behavior.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"sarah" <sarah@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:676B74A3-E230-474D-A782-0689369E6D30@xxxxxxxxxxxxxxxx
Do you mean that I reset with the old password?


"Tibor Karaszi" wrote:

Hmm, just as a test, does it work if you provide the old password? (I
know it isn't what you are looking for, but just as a troubleshooting
measure...)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"sarah" <sarah@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:264F1183-8448-41D6-8A95-2564A1752CB2@xxxxxxxxxxxxxxxx
> Hi Tibor,
>
> I tried and it gives the helpdesk the same error saying
> "Cannot alter login ' xxx', because it doesn't exist or you do > not
> hav
> permission"
>
> I don't understand. This account has security admin right as > well.
>
> any idea?
>
> Thanks
> Sarah
>
> "Tibor Karaszi" wrote:
>
>> Did you try GRANT ALTER ANY LOGIN TO loginName?
>>
>> -- >> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "sarah" <sarah@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:2A35FDE1-1666-4E4A-8D2F-8FC922F7FE85@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I'm using sql2005. I want to setup a sql login for our >> > helpdesk
>> > to
>> > reset sql
>> > login password only.
>> >
>> > Please advice,
>> >
>> > Thanks
>> > Sarah
>>
>>



.

Relevant Pages