[THIN] Re: moving sql server

  • From: "Boggan, Michael" <MichaelBoggan@xxxxxxxxxxxxxxxx>
  • To: <thin@xxxxxxxxxxxxx>
  • Date: Mon, 24 Sep 2007 11:56:07 -0500

Is it possible to change the name of a Citrix farm without creating a
new one?

Michael Boggan
Senior Citrix Administrator
Temple-Inland, Inc
ph. 512-434-5822
 
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Berny Stapleton
Sent: Monday, September 24, 2007 4:21 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: moving sql server

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
************************************************

**********    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: