That is correct, you can copy and modify the exist dsn file. If anything, you should be able to use the existing (without copying) mf20.dsn file if the database/database server name hasn't changed. Joe -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Seán Sent: Friday, November 14, 2008 3:05 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Change the login to the Data Store I have a requirement to change the login to the Data Store from the Domain Administrator account to a Service Account. The Farm is PS 4.6, database is SQL 2000. A couple of questions on this: 1. Apart from DBO, what other permissions on the database will the Service Account need? 2. How do I create the new DSN file? Can I copy the existing one and modify that? I understand that I would then use dsmaint config /user:username /pwd:password /dsn:dsnfilename Any advice much appreciated! - Seán Carr ************************************************ For Archives, RSS, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: //www.freelists.org/list/thin NEW! Follow Thin List on Twitter! http://twitter.com/thinlist Thin List discussion is now available in blog format at: http://thinmaillist.blogspot.com HOT! Thinlist MOBILE Feed! http://thinlist.net/mobile Thinlist quick pick http://thinlist.net ************************************************ ************************************************ For Archives, RSS, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: //www.freelists.org/list/thin NEW! Follow Thin List on Twitter! http://twitter.com/thinlist Thin List discussion is now available in blog format at: http://thinmaillist.blogspot.com HOT! Thinlist MOBILE Feed! http://thinlist.net/mobile Thinlist quick pick http://thinlist.net ************************************************