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

From: Gabi Tianu (gabi_tianu_at_hotmail.com)
Date: 10/20/05 

Date: Thu, 20 Oct 2005 09:30:57 +0300

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: .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: 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: Authenticating in SQL Server via MS Access 2002
    ... account and this account will be used by Access to authenticate with ... > 1.Database is on SQL Server 2000 ... > SQL using Windows authentication. ... > it is then that they are asked for their SQL Server login. ...
    (microsoft.public.access.externaldata)
  • Re: Windows Services and SQL Server
    ... SqlClient class with a regular SQL Server login? ... because you're running the service as local system (or ... to run the service under a differnt user account which does have ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to change sql login username instead of create new one.
    ... sysxlogins is the name of the table, ... you can rename a SQL Server Login. ... In SQL 2000 you can not rename a SQL Server Login or database user. ...
    (microsoft.public.sqlserver.security)