Re: setup a sql login which can only reset password

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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

  • Re: setup a sql login which can only reset password
    ... Tibor Karaszi, SQL Server MVP ... 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 ...
    (microsoft.public.sqlserver.server)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
    ... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)