[THIN] Re: Moving data store to a different sql server
- From: "Jim Hathaway" <JimH@xxxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2004 12:44:45 -0700
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
//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:
