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