[THIN] Re: Moving data store to a different sql server

Angus, 

I've used the following process many times to move the IMA between SQL and have 
had no failures come out of it yet. 

HTH

J


Ensure your servers are using TCPIP to connect to your SQL database and not 
Named Pipes. You can check this by opening the file C:\Program 
Files\Citrix\Independant Management Architecture\MF20.DSN The file should have 
the following lines:

Address=YOURSERVERNAME,1433
Network=DBMSSOCN

If not include the above two lines in your MF20.DSN file then run the following 
command:
dsmaint config /user:SQLusername /pwd:password 
/dsn:C:\PROGRA~1\Citrix\INDEPE~1\MF20.DSN

This should successfully connect to the DS via TCPIP. Stop and restart the IMA 
service. You should check you are now connecting to the DS via TCPIP by the 
netstat -a command. This should show:

on Win2K: TCP yourwtsname:2162 yoursqlservername:ms-sql-s ESTABLISHED
on TSE: TCP yourwtsname:2162 yoursqlservername:1433 ESTABLISHED

To migrate the DS:
1) On your old SQL server, backup the database using the Enterprise Manager. 
Select your SQL database which holds the DS and select All Tasks > Backup 
Database. Select a file location. Select the Verify backup upon completion on 
the Options tab.
2) On your new SQL server select All Tasks > Restore Database. Type in the name 
of the database (should be the same as the database name on the old server). 
You may also need to change the restore location if your database is located in 
a different path than the old server.
3) Now follow the steps on page 73 of the MetaFrame Admin Guide to create an 
Admin user for the database. We found you needed to create a new user even 
though you had an Admin user defined on your old SQL server. Say citrixadmin on 
your old SQL server, and citrixadmin2 on your new SQL server
4) On each of your terminal servers edit the MF20.DSN file:

[ODBC]
DRIVER=SQL Server
UID=citrixadmin2 <-put in new admin name
Address=NEWSQLSERVERNAME,1433 <- enter new SQL server name
Network=DBMSSOCN
WSID=YOURTSNAME
APP=Citrix IMA
SERVER=EWSQLSERVERNAME <- put in new SQL server name
Description=citrix

Run the following command:
dsmaint config /user:citrixadmin2 /pwd:password 
/dsn:C:\PROGRA~1\Citrix\INDEPE~1\MF20.DSN

Stop and restart the IMA service. The server should now be accessing the DS on 
your new SQL server. Create a test published app. Your old Terminal servers in 
the farm won't see this new published app, but as you migrate your servers to 
the new DS they will see this test published app. Repeat step 4 for each 
Terminal Server in the farm finishing with the Data Collector.

-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of 
Angus Macdonald
Sent: Tuesday, August 17, 2004 2:58 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Moving data store to a different sql server

Thanks for that. I hope I have a lot less trouble than that moving the data
across! I've done a test import to the new server and didn't have to jump
through any hoops.

I could do with more information about the Citrix end. As far as I can tell
I create a new DSN, pointing to the newly moved database, run DSMAINT to use
the new DSN, restart the IMA service and everything will be flowers and
rainbows. Is it that easy, assuming the data migration goes OK?

-----Original Message-----
From: James Hill [mailto:HillJ@xxxxxxxxxxxxxxxxxx]
Sent: 17 August 2004 10:35
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Moving data store to a different sql server


Someone just asked how to do this and I've accidently nuked the email.

For whoever it was, try this from the list archives
http://www.freelists.org/archives/thin/12-2003/msg00301.html

Regards,

James.
********************************************************
This Weeks Sponsor RTO Software
Do you know which applications are abusing your CPU and memory?
Would you like to learn? --   Free for a limited time!
Get the RTO Performance Analyzer to quickly learn the applications,
users, and time of day possible problems exist.
http://www.rtosoft.com/enter.asp?id=320
********************************************************** 
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm

Gallai'r e-bost yma gynnwys gwybodaeth gyfrinachol a/neu ddeunydd hawlfraint.  
Os ydych chi'n meddwl eich bod wedi derbyn yr e-bost yma drwy gamgymeriad rydym 
yn ymddiheuro am hyn; peidiwch os gwelwch yn dda â datgelu, anfon ymlaen, 
printio, copïo na dosbarthu gwybodaeth yn yr e-bost yma na gweithredu mewn 
unrhyw fodd drwy ddibynnu ar ei gynnwys: gwaherddir gwneud hynny'n gyfan gwbl a 
gallai fod yn anghyfreithlon. Rhowch wybod i'r anfonwr fod y neges yma wedi 
mynd ar goll cyn ei dileu.
 
Mae unrhyw safbwynt neu farn a gyflwynir yn eiddo i'r awdur ac nid ydynt o 
anghenraid yn cynrychioli safbwynt neu farn Ymddiriedolaeth GIG Gogledd 
Orllewin Cymru.

Gallai cynnwys yr e-bost yma gael ei ddatgelu i'r cyhoedd o dan Gôd Bod yn 
Agored y GIG neu Ddeddf Rhyddid Gwybodaeth 2000.  Nid oes modd gwarantu 
cyfrinachedd y neges ac unrhyw ateb. 

Bydd y neges yma ac unrhyw ffeiliau cysylltiedig wedi cael eu gwirio gan 
feddalwedd canfod firws cyn eu trosglwyddo.  Ond rhaid i'r sawl sy'n derbyn 
wirio rhag firws ei hun cyn agor unrhyw ymgysylltiad.  Nid yw'r Ymddiriedolaeth 
yn derbyn unrhyw gyfrifoldeb am unrhyw golled neu niwed a allai gael ei achosi 
gan firws meddalwedd.


This e-mail may contain confidential information and/or copyright material.  If 
you believe that you have received this e-mail in error please accept our 
apologies; please do not disclose, forward, print, copy or distribute 
information in this e-mail or take any action in reliance on its contents: to 
do so is strictly prohibited and may be unlawful.  Please inform the sender 
that this message has gone astray before deleting it.

Any views or opinions presented are to be understood as those of the author and 
do not necessarily represent those of the North West Wales NHS Trust.

The contents of this e-mail may be subject to public disclosure under the NHS 
Code of Openness or the Freedom of Information Act 2000.  The confidentiality 
of the message and any reply cannot be guaranteed.

This message and any attached files will have been checked with virus detection 
software before transmission.  However, recipients must carry out their own 
virus checks before opening any attachment.  The Trust accepts no liability for 
any loss or damage, which may be caused by software viruses.

********************************************************
This Weeks Sponsor RTO Software
Do you know which applications are abusing your CPU and memory?
Would you like to learn? --   Free for a limited time!
Get the RTO Performance Analyzer to quickly learn the applications,
users, and time of day possible problems exist.
http://www.rtosoft.com/enter.asp?id20
********************************************************** 
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm


********************************************************
This Weeks Sponsor RTO Software
Do you know which applications are abusing your CPU and memory?
Would you like to learn? --   Free for a limited time!
Get the RTO Performance Analyzer to quickly learn the applications,
users, and time of day possible problems exist.
http://www.rtosoft.com/enter.asp?id20
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm

Other related posts: