Domain name change for user group security

From: Jennifer Fry (jfry_at_grede.com)
Date: 05/27/03 

Date: Tue, 27 May 2003 08:34:17 -0700

This past weekend we added a new domain. All of our user
groups added to SQL server were authenticated through the
old domain (CompanyNT/UserGroup). How do I update the
groups in SQL server to authenticate through the new
domain (CompanyW2k/UserGroup)? I really don't want to
have to manually re-create them and re-assign permissions.

I'm assuming that I am going to have to do some scripting
for this, but I'm not sure if there is a stored procedure
that I can run that will simplify it or not.

Thanks in advance for your help.

Relevant Pages

  • Re: Domain name change for user group security
    ... easiest way is to add the new logins, ... > groups added to SQL server were authenticated through the ... > old domain (CompanyNT/UserGroup). ... > groups in SQL server to authenticate through the new ...
    (microsoft.public.sqlserver.security)
  • Re: "Access Denied" to sql server ....help...
    ... can access the rest of the asp.net app. ... >The ASP.NET user account is a local account. ... >want to authenticate to a different box. ... >> the sql server does not exist. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Trusted connections??
    ... I've got an application I want to authenticate to the domain i.e. an ... connection, the system will either use the account that ASP.NET runs under ... this inconsistency odd, which I find odd. ... SQL server use it. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Does this authentication scheme work?
    ... >I am building a Pocket PC app against an Oracle back end using .NET Compact ... The presentation layer needs to also work for SQL Server CE. ... > up a test scenario but failed to be able to authenticate. ... > up a Windows account for each user and configuring the virtual directory ...
    (microsoft.public.sqlserver.replication)
  • Does this authentication scheme work?
    ... I am building a Pocket PC app against an Oracle back end using .NET Compact ... Framework and Oracle's sync technology (this includes Oracle Lite on the ... The presentation layer needs to also work for SQL Server CE. ... I want each user to be forced to authenticate with a user name and password ...
    (microsoft.public.sqlserver.replication)