Change logins domain in SQL2000 with Windows 2000

From: Javier Rosas (jrosashe@accival.com.mx)
Date: 10/31/02 

From: "Javier Rosas" <jrosashe@accival.com.mx>
Date: Wed, 30 Oct 2002 19:17:00 -0800

Hi all,

I will upgrade WinNT to Windows 2K and I will upgrade SQL7
to SQL2K, too.

I have a dude, I need to change my users to another
domain, with a procedure and a tool, they mantain the same
policy permissions in OS, my question is: what's up with
my users in SQL? Do I need to add each login again and
asign permissions again or exist any procedure to change
all SQL logins with the same permissons when they change
of domain?

I think, it's like renaming the login in syslogins or
sysxlogins.

Anybody help me?

Thanks in advance.
Javier Rosas

Relevant Pages

  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Re: ODBC in MS Access ignores DSN authorization method
    ... login doesn't have permissions, you get an error. ... to use a trusted connection or a SQL login, ... >permissions, and instead use the PUBLIC permissions. ... >When the Windows login I am using has access to the database, ...
    (microsoft.public.sqlserver.odbc)