Re: How to move current SQL server from Domain A to Domain B?
From: Che Bliayang (cbliayang_at_csmcorp.net)
Date: 10/29/04
- Next message: SteveWang: "Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
- Previous message: Bob: "MDAC Installation failure on SQL 2K with Windows 2000 Pro SP4"
- In reply to: Keith Kratochvil: "Re: How to move current SQL server from Domain A to Domain B?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 16:00:21 -0500
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?
>> >>
>> >>
>> >
>>
>>
>
- Next message: SteveWang: "Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
- Previous message: Bob: "MDAC Installation failure on SQL 2K with Windows 2000 Pro SP4"
- In reply to: Keith Kratochvil: "Re: How to move current SQL server from Domain A to Domain B?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
