[THIN] Re: moving sql server
- From: "Berny Stapleton" <berny@xxxxxxxxxxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Mon, 24 Sep 2007 10:20:30 +0100
Yes, that's very possible, it's one of the DSMAINT commands; config.
http://www.thin-world.com/MFCommands/dsmaint.htm
http://support.citrix.com/article/CTX677542
don't forget to do a /recreatelhc as well.
So:
Stop the IMA service.
Go into %PROGRAMFILES%\Citrix\Independent Management Architecture\
There should be a file there called MF20.dsn. Modify this file so that
it points into the new database server.
If you are still using XP, I have found that XP doesn't like talking
to named SQL server instances, it only likes talking to the default
instance, so if you are pointing to a SQL instance that isn't default,
create a SQL Alias using cliconfg and then point to the database using
the SQL Alias.
Then run the command:
dsmaint config /user:username /pwd:password
/dsn:%PROGRAMFILES%\Citrix\Independent Management
Architecture\mf20.dsn
dsmaint recreatelhc
Start the IMA service.
As you move the server from one IMA database to another, you should
have a couple of copies of the CMC up. One should be on a server which
is connected to the old IMA database, one should be connected to the
new, and one should be on the server you are moving.
Create an app in the old copy of the database and make sure that you
can't see it when you have moved the server, create an app on the
server connected to the new database and make sure you can see that on
the server you just moved, create an app on the server you just moved
and make sure you can see it on the see it on the other server
connected to the new database. This will ensure you know for certain
that it's connected to the new database.
That should do it.
Berny
On 21/09/2007, Boggan, Michael <MichaelBoggan@xxxxxxxxxxxxxxxx> wrote:
>
>
>
>
> Is it possible to move a sql server containing the datastore of a farm, and
> the citrix servers, to a new domain without having to redo the farm? Pretty
> sure the citrix servers are safe but not sure about sql. I am not a sql
> expert by any means. If we change the domain membership of a sql server
> should we have any problems with the datastore database?
>
>
>
> Thanks,
>
>
>
> Michael Boggan
>
> Senior Citrix Administrator
>
> Temple-Inland, Inc
>
> ph. 512-434-5822
>
>
>
> ********** Confidentiality Notice **********
> This electronic transmission and any attached documents or other writings
> are confidential and are for the sole use of the intended recipient(s)
> identified above. This message may contain information that is privileged,
> confidential or otherwise protected from disclosure under applicable law.
> If the receiver of this information is not the intended recipient, or the
> employee, or agent responsible for delivering the information to the
> intended recipient, you are hereby notified that any use, reading,
> dissemination, distribution, copying or storage of this information is
> strictly prohibited. If you have received this information in error, please
> notify the sender by return email and delete the electronic transmission,
> including all attachments from your system.
>
>
************************************************
For Archives, RSS, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
//www.freelists.org/list/thin
************************************************
Other related posts:
