[THIN] Re: DS move to another server
- From: "Jim Hathaway" <JimH@xxxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Wed, 4 Jun 2003 08:25:04 -0700
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
Other related posts:
