Re: How to move current SQL server from Domain A to Domain B?

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 11/01/04 

Date: Mon, 1 Nov 2004 08:35:56 -0600

Hopefully everything will go well. 

-- 
Keith
"Che Bliayang" <cbliayang@csmcorp.net> wrote in message
news:O%23D3OpfvEHA.3728@TK2MSFTNGP12.phx.gbl...
> Users are authenticating to SQL using a local SQL login ID/PWD. We are
> retiring the old domain and as far as windows security, there's only one
> folder that's shared with the everyone access permission. We are not using
> SQL mail as well.
>
> With this info, sounds like I should be okay to simply remove this server
> from the old domain to the new domain?
>
> Thanks for your help!
>
> "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
> news:%23U8H2rcvEHA.200@TK2MSFTNGP11.phx.gbl...
> > How do you authenticate users?  SQL Server security?  Windows Security?
> > Are
> > you removing the old domain?  If you are using Windows security and are
> > removing the domain you will have to recreate your security setup.
> >
> > Are you using SQLMail?  This may stop working until you reconfigure the
> > profile.
> >
> > Other than that, I cannot think of any major "gotchas."
> >
> > Someone else might jump in with one that might cause me to slap my head
> > and
> > say "oh yeah" but those are probably the biggies.
> >
> > -- 
> > Keith
> >
> >
> > "Che Bliayang" <cbliayang@csmcorp.net> wrote in message
> > news:OrmXGQcvEHA.2540@TK2MSFTNGP09.phx.gbl...
> >> What else will I be looking at as well besides the sql service account?
> >>
> >> "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
> >> news:eCZGWWRvEHA.2520@TK2MSFTNGP15.phx.gbl...
> >> >I assume that you are probably running the SQL Server services using a
> >> > domain account.  This will be your first hurdle on the machine that
is
> >> > changing domains.
> >> >
> >> > -- 
> >> > Keith
> >> >
> >> >
> >> > "Che Bliayang" <cbliayang@csmcorp.net> wrote in message
> >> > news:%23fkwPCRvEHA.1204@TK2MSFTNGP10.phx.gbl...
> >> >> We are currently consolidating our 2 domains into one. What risk
> >> > assessment
> >> >> should I be looking for regarding moving the SQL server to the new
> >> >> Domain?
> >> >> Will anything break?
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
>

Relevant Pages

  • Re: How to move current SQL server from Domain A to Domain B?
    ... Users are authenticating to SQL using a local SQL login ID/PWD. ... retiring the old domain and as far as windows security, ... > removing the domain you will have to recreate your security setup. ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows Authentication to SQL Server?
    ... required to get the logons configured in SQL and what your options are. ... working with individual accounts may be fine for you. ... You should definitely see the individual Windows logons for the users ... or SQL security but the article is discussing Windows security. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Windows Authentication to SQL Server?
    ... I'm not much of a SQL guy so I'm not totally sure on all the details required to get the logons configured in SQL and what your options are. ... you'd want a role mapping scheme where windows groups end up getting mapped to SQL roles for the actual security implementation so that you have a nice abstraction layer in SQL for managing the actual permissions and can use AD and groups as a way of assigning membership to those roles. ... Depending on the number of users involved, working with individual accounts may be fine for you. ... this can be done with either Windows security or SQL security but the article is discussing Windows security. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Windows Authentication to SQL Server?
    ... app and SQL Server were to be set up in the Delegation method would there be ... individual Windows accounts) in that when SQL Profiler is run in the ... In delegation, authentication to SQL server is done as the user ... SQL security but the article is discussing Windows security. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: minimum OS user level to operate SQL Server
    ... Just the service that runs SQL will need windows security. ... Making them a system administrator would give them full control over SQL. ... > full control of SQL Server. ...
    (microsoft.public.sqlserver.security)
Loading