Steps to rename a user in SQL Server 2000

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: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
    ... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
    (microsoft.public.sqlserver.clustering)
  • 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)