You will need to do the follow: Backup all servers=20 Setup SQL to allow SQL athentication. Create SQL account and assign permission to the Datastore Database Create a new file DSN on each of the MF servers. Perform dsmaint config on each server, stop and restart the IMA service. -----Original Message----- From: Chris Fraser [mailto:chrisfraser@xxxxxxxxxx] Sent: Tuesday, April 08, 2003 10:47 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] How to change Data Store authentication method Hi there all, Has anyone had to migrate their SQL data store from windows =3D authentication to SQL authentication? I have inherited an existing farm that uses the domain admin credentials = =3D for the IMA login to the data store. For obvious reasons I would like to =3D migrate this to a sql account. Do I do a dsmaint config? Do I just change the DSN on each server using = =3D the ODBC control panel? Any ideas/experiences? Thanks ----- Chris Fraser, ThinApse Corporation http://www.thinapse.com 604 638 8456 chrisfraser@xxxxxxxxxx ******************************************************** This Week's Sponsor - ThinPrint Simply the best print solution for Microsoft Terminal Services=20 and Citrix Metaframe. http://www.thinprint.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 - ThinPrint Simply the best print solution for Microsoft Terminal Services and Citrix Metaframe. http://www.thinprint.com/ ********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thethin.net/citrixlist.cfm