[THIN] Re: DS move to another server

  • From: "Schneider, Chad M." <CMSchneider@xxxxxxxxx>
  • To: thin@xxxxxxxxxxxxx
  • Date: Wed, 4 Jun 2003 10:28:25 -0500

Why run the dsmaint?  I am leaving the .dsn file named as is, not creating a
new one, but changing the existing mf20.dsn file to point to the new server.

I tried copying the .dsn, and altering it, and running dsmaint config, which
failed, then thought, why create a new .dsn, why not just change the
existing?

Seems to work fine.  IMA stops and restarts fine.

Any reason this should not work?


-----Original Message-----
From: Jim Hathaway [mailto:JimH@xxxxxxxxxxxxxxx] 
Sent: Wednesday, June 04, 2003 10:25 AM
To: thin@xxxxxxxxxxxxx

Chad, you need to be running Dsmaint on all servers to complete this move.
I've used the process lised below to move IMA DB's between SQL servers
without mishap . . So far.=20

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=3DYOURSERVERNAME,1433
Network=3DDBMSSOCN

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=3DSQL Server
UID=3Dcitrixadmin2 <-put in new admin name
Address=3DNEWSQLSERVERNAME,1433 <- enter new SQL server name
Network=3DDBMSSOCN WSID=3DYOURTSNAME APP=3DCitrix IMA
SERVER=3DEWSQLSERVERNAME <- put in new SQL server name Description=3Dcitrix

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: Schneider, Chad M. [mailto:CMSchneider@xxxxxxxxx]=20
Sent: Wednesday, June 04, 2003 7:13 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] DS move to another server


Content-Type: text/plain;=20
 charset=3Dus-ascii
Content-Transfer-Encoding: 7bit
Appears that moving the DataStore SQL DB to another SQL server, changing the
mf20.dsn file to point to that new server and restarting the IMA, is all
that has to be done....Looks like it is running fine?
=20
Am I missing anything?
=20

Chad Schneider
Technology Analyst
Bemis IT
920-303-7609=20




-- No attachments (even text) are allowed --
-- Type: image/jpeg
-- File: Notebook.jpg


********************************************************
This Week's Sponsor - Appsense Technologies New! AppSense Optimizer is a new
product from AppSense=20 designed to increase the user capacity of your
servers.=20 http://www.appsense.com/
**********************************************************

For Archives, to Unsubscribe, Subscribe or=20 set Digest or Vacation mode
use the below link:
http://thethin.net/citrixlist.cfm
********************************************************
This Week's Sponsor - Appsense Technologies New! AppSense Optimizer is a new
product from AppSense designed to increase the user capacity of your
servers. 
http://www.appsense.com/
**********************************************************

For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use
the below link:
http://thethin.net/citrixlist.cfm

********************************************************
This Week's Sponsor - Appsense Technologies
New! AppSense Optimizer is a new product from AppSense 
designed to increase the user capacity of your servers. 
http://www.appsense.com/
**********************************************************

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm

Other related posts: