Re: Migrating SQL Server to new Domain

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: H. Cao (HCao_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Mon, 21 Jun 2004 18:45:02 -0700

Thank you, Paul. I'll keep these KB articles close at hand.

"Paul Ibison" wrote:

> Here are some general guidelines to be followed using Detach / Attach, which
> apply within a domain or between domains:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&sd=tech
> As far as moving across domains, the windows logins will need restructuring
> to replace the domainname part. Details in there articles:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;240872
> http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
> If the servername is being altered, you'll also need to consider
> replication - settings will not be preserved. It's best to script out the
> replication settings on the original server, transfer the databases, edit
> the scripts with the new names then apply the scripts.
> jobs - master/slave jobs (and windows login names of owners but this is
> covered above)
> general TSQL - fully qualified names are sometimes used to obtain the output
> of a stored procedure as a resultset in TSQL. Look for OPENROWSER and
> OPENDATASOURCE.
> HTH,
> Paul Ibison
>
>
>

Relevant Pages

  • Re: For the Cardinal he mediating role ends
    ... Desperately grasping at straws as always, eh, Paul Lamot? ... The articles of the Penal Code now used more frequently to suppress ... the penalty is a prison term from one to three years ... cover to imprison people for political reasons on the grounds that they ...
    (soc.culture.cuba)
  • Re: Ranking formular in Access?
    ... >> Hi, Paul. ... >>> Express Scripts, ... >>> Charting the future of pharmacy ...
    (microsoft.public.access.queries)
  • Re: Access is just to hard to understand
    ... "Paul " wrote: ... > Express Scripts, ... > Charting the future of pharmacy ...
    (microsoft.public.access.gettingstarted)
  • Re: the owner of posting should be able to delete the posting
    ... > Hi Paul ... I've made a lot of annoying typos that I ... >> Express Scripts, ... >> Charting the future of pharmacy ...
    (microsoft.public.excel.misc)
  • Re: Testing for daylight savings on a GMT server
    ... Other scripts I set the TZ specifically, ... DST was in effect or not, but while in GMT I guess it can't deliver ... Paul Lalli wrote: ... >> TZ variable to a local time, but I haven't seen any changes. ...
    (comp.unix.solaris)