Re: sql logins with Windows Authentication.
From: Steve Thompson (stevethompson_at_nomail.please)
Date: 08/16/04
- Next message: Steve Thompson: "Re: Windows authentication in domain"
- Previous message: MMRR_at_MINDSPRING.COM: "sql logins with Windows Authentication."
- In reply to: MMRR_at_MINDSPRING.COM: "sql logins with Windows Authentication."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 16 Aug 2004 14:50:54 -0400
<MMRR@MINDSPRING.COM> wrote in message
news:6aa501c483aa$9882e290$a301280a@phx.gbl...
> We have recently migrated from windows NT to Active
> Directory and switched to a new domain name. I have many
> accounts that are using Windows Authentication to connect
> to db1. When I look at the users on db1 they have login
> name as none and username is olddomain\username. How do I
> update all these accounts to the new domain name in SQL?
> Is this something that is done by the AD administrating
> the user accounts?
This should take care of it for you:
HOW TO: Resolve Permission Issues When You Move a Database Between Servers
That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=240872
Conceptually, correcting your login domains is similar to moving your
databases between servers, you'll need to remap your new domain\accounts to
the old SIDs.
Steve
- Next message: Steve Thompson: "Re: Windows authentication in domain"
- Previous message: MMRR_at_MINDSPRING.COM: "sql logins with Windows Authentication."
- In reply to: MMRR_at_MINDSPRING.COM: "sql logins with Windows Authentication."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
