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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/20/05


Date: Thu, 20 Oct 2005 08:41:48 +0200

sysxlogins is the name of the table, and syslogins is a view. So, the only place where a change
would be needed is sysxlogins. However, hacking system tables is not supported and Pleo would be on
his own by doing that.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Gabi Tianu" <gabi_tianu@hotmail.com> wrote in message news:eS3wd$T1FHA.1108@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> Yes, you can rename a SQL Server Login. You have to manually change values in master.dbo.syslogins 
> and master.dbo.sysxlogins.
>
> Gabi Tianu
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message 
> news:uW5cTJ80FHA.916@TK2MSFTNGP10.phx.gbl...
>> Hi,
>>
>> As Tibor mentioned; In SQL 2000 you can not rename a SQL Server Login or database user.
>>
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "Pleo" <rx8@hotmail.com> wrote in message news:ON0lytv0FHA.404@TK2MSFTNGP09.phx.gbl...
>>> 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: How to change sql login username instead of create new one.
    ... you can rename a SQL Server Login. ... Gabi Tianu ...
    (microsoft.public.sqlserver.security)
  • Re: .udl file?
    ... OK button and then seeing the "SQL Server Login" prompt, ... Connection" checkbox is checked on which would explain why the initial ...
    (microsoft.public.access.externaldata)
  • Re: Dependencies in Enterprise Manager
    ... If you rename an executable (e.g. ... SQL Server database objects should be treated similarly to other ... > Dependencies' can give the wrong answers, but I don't remember them all. ... > All of this seems to be a HUGE hole in Enterprise Manager. ...
    (microsoft.public.sqlserver.programming)
  • Re: sqlserver connection - need help desperately!
    ... > You are connecting to a remote SQL Server ... > The SQL Server accepts both Windows and SQL Server authentication. ... > SQL Server login that's authorized to use your database. ... > the ASP.NET account in the SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Renaming Computer Running SQL or MSDE
    ... SQL Server will reconfigure itself to the new machine name just ... > problems encountered when renaming a computer that is running SQL or ... > to suspect that it is permissible to rename a computer that is running ... > Personal Ed, MSDE) ...
    (microsoft.public.sqlserver.msde)