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

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 10:19:54 -0500

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: Utter madness!
    ... It is just Windows security stuff. ... You can get a trusted connection back to SQL server. ... ASP.NET account (either processModel or app pool identity depending on ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: how do you set up an admin account?
    ... If you log into Windows as an account that has administrative privileges on ... the box and then log into SQL Server with Windows security, ... administrator in SQL Server and should be able to create logins to your ...
    (microsoft.public.sqlserver.setup)
  • How to protect db from being accessed by unauthorized applications
    ... I want to protect an SQL Server database from being accessed by any other ... Create the same user on the SQL Server. ... using Windows security (no password necessary when logging onto SQL ... LogonUser API call. ...
    (microsoft.public.sqlserver.security)
  • Why doesnt "simple" login work? CONFUSED!
    ... I need to admit right up front that I get VERY confused about the security ... implementation of SQL Server and it's relationship with Windows security. ... EXEC sp_grantdbaccess 'CRReports', 'CRReports' ...
    (microsoft.public.sqlserver.server)
  • Re: password on opening
    ... then consider setting a BIOS boot password. ... >You might also try something like removing the mouse. ... Microsoft MVP for Windows Security ... >> Dave Metz ...
    (microsoft.public.security)