Re: Steps to rename a user in SQL Server 2000

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: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ...
    (microsoft.public.win32.programmer.wmi)
  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ...
    (microsoft.public.windows.server.security)
  • Re: SQL job owner and right
    ... It is the wrong type of account. ... who can login with that account can manage those jobs. ... Windows group that both windows users belong to and have that own the ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Users
    ... To change sa login do I connect via an ODBC connection - and is an account with local admin on my machine would accomplish that change. ... What type of access would you allow network engineers to have in sql, the main functionality is a network back up they run and include SQL in that. ...
    (microsoft.public.sqlserver.server)
  • 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)