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

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 10/18/05 

Date: Tue, 18 Oct 2005 14:29:47 +0530

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: Renamed Windows login not found in SQL Server 2000
    ... rename has been moved up to next week. ... Service and the Server service. ... > 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: Cannot create a SQL user logon
    ... Tibor Karaszi, SQL Server MVP ... >>> Login to Query Analyzer and execute the below query to check if login ...
    (microsoft.public.sqlserver.setup)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Renamed Windows login not found in SQL Server 2000
    ... I am running SQL Server 2000 SP2 with Windows ... login gets corrupted) I am unable to add the new login to ... group prefers to do a rename rather than a delete of the ...
    (microsoft.public.sqlserver.security)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)