Re: Steps to rename a user in SQL Server 2000

Personally I don't know of a way to do it in 2000 only 2005 without creating a new one. Maybe this is a good time to upgrade:).

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"KnightFall1" <KnightFall1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3759A87E-7603-49A7-863B-195D279C6529@xxxxxxxxxxxxxxxx
Hi Andrew,

I only mentioned the comment about mapping the login to another user since
that was mentioned in the BOL example along with the sp_change_users_login
stored procedure.

I'm mainly curious if it possible to just rename a SQL account in SQL 2000.
Is it possible OR does a new login always have to be created if you want the
login to be different?






"Andrew J. Kelly" wrote:

What do you mean by map an existing login to a new account? Logins are at
the server level and users are at the db level. SQL Logins are not mapped to
any account they are just Logins. The Logins is mapped to one or more Users.
sp_change_users fixes the mapping between Logins and Users. If you want to
change a Login from Login1 to Login2 I believe you will need to create a new
one and map all the users to that new Login. But I must be missing something
as I don't see why you would want to do that. Can you give more details?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"KnightFall1" <KnightFall1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C35083F-4471-46C0-A573-C34DD99BA15E@xxxxxxxxxxxxxxxx
>I have what is hopefully a simple question.
>
> I have a SQL 2000 Enterprise server with SP4. I want to be able to > rename
> an
> existing SQL account to something else.
>
> I see that there is a sp_change_users_login stored procedure which
> initially
> looked promising but based on the 3 examples shown in Books Online this
> stored procedure will not work. Unlike the examples that BOL gives, I'm
> not
> trying to create a new login and then map an existing login to a new
> account.
> Since I'm running SQL 2000 and not SQL 2005, I can't use the ALTER > LOGIN
> command.
>
> I just want to rename the SQL login account from "User1" to "User2"
> (password stays the same).
>
> How do I do that?
>
>



.

Relevant Pages

  • 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/Access security questions
    ... (also make sure to remove the built-in menus and substitute with your ... Access after a set number of login attempts. ... >single SQL account the users share. ... Can I do this using SQL accounts only? ...
    (microsoft.public.sqlserver.security)
  • 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)
  • RE: Getting Challenged when using SQL connection on .aspx page
    ... What would happen if i removed integrated security=sspi from the connection ... Just want the login token to be passed, ... Have webpage with following connection in the ... I have account to the database on the SQL server. ...
    (microsoft.public.dotnet.framework.aspnet)