Scott, Here is what you need to do: 1- Create an empty SQL DB and assign and account password with owner privileges. If you have a DBA delegate this task. 2- You need to create a DSN file and test connectivity from your main MF server to the DB server. Copy your DSN file to all your MF servers. 3- Migrate your IMA DB from Access to SQL using the command DSMAINT MIGRATE using the DSN as a parameter 4- Re-configure all your MF servers using the command DSMAINT CONFIG to use the new SQL IMA DB, then restart the IMA service on each MF server. You are done! Abdul Abdo _____ From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Newman, Phil Sent: Tuesday, June 28, 2005 10:47 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Metaframe Data Base to SQL Look at the command line utility DSMAINT: P:\>dsmaint Perform various configuration tasks for the IMA data store. DSMAINT [ CONFIG | BACKUP | FAILOVER | COMPACTDB | COMPARE | MIGRATE | PUBLISHSQLDS | RECOVER | RECREATELHC ] -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Scott Skrogstad Sent: 28 June 2005 15:23 To: thin@xxxxxxxxxxxxx Subject: [THIN] Metaframe Data Base to SQL I have a Farm of 4 servers, some running win2k some on 2003. My first server holds the database on the config. I want to move that to one of my SQL servers. I have looked on Citrixs site for a doc to help with that but I have found nothing at this point. Can anyone point me in the right direction ? Scott Skrogstad Computer Integration Inc. ******************************************************** This Weeks Sponsor: Lakeside Software SysTrack is the easiest to use, most complete way to monitor system and application performance. SysTrack combines comprehensive monitoring capabilities with hardware/software inventory, change management, user/web auditing, and reporting to create a total management solution. Evaluation at: http://www.LakesideSoftware.com ********************************************************** Now available BriForum-The Video! http://www.brianmadden.com/store/pc/viewPrd.asp?idproduct=1&idaffiliate= 3 Useful Thin Client Computing Links are available at: http://thin.net/links.cfm ThinWiki community - Excellent SBC Search Capabilities! http://www.thinwiki.com *********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thin.net/citrixlist.cfm