Re: How to change sql login username instead of create new one.

From: Pleo (rx8_at_hotmail.com)
Date: 10/17/05 

Date: Mon, 17 Oct 2005 17:16:46 +0800

I'm not familiar sql. At enterprise server (sql2000) > security > logins >
(want to change name here).
Anyway, I guess it can't be changed there. Thanks.

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> ???
news:%23R4Ixpv0FHA.3068@TK2MSFTNGP10.phx.gbl ???...
> Can you explain what you mean by "change sql login username"? Are you
referring to the login name
> (in master) or the user name (in your database)? Anyhow, you cannot change
the name of a login or a
> user, You will be able to rename a user in 2005, not sure about login,
though.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Pleo" <rx8@hotmail.com> wrote in message
news:eVAlmnv0FHA.2428@tk2msftngp13.phx.gbl...
> > As title, thanks!
> >
> >
>

Relevant Pages

  • Re: setup a sql login which can only reset password
    ... I couldn't test it right now, because if I login as helpdesk, i reset the ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • 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: 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. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: setup a sql login which can only reset password
    ... Do you mean that I reset with the old password? ... Tibor Karaszi, SQL Server MVP ... "Cannot alter login ' xxx', because it doesn't exist or you do not ...
    (microsoft.public.sqlserver.server)
  • Re: Lost Login Name on Backup
    ... Read about sp_change_users_login in Books Online. ... Tibor Karaszi, SQL Server MVP ... does not have a Login Name when I select Users. ...
    (microsoft.public.sqlserver.server)