How to edit MF20.dsn file in XenApp 6.5 server?

goprasad
goprasad used Ask the Experts™
on
Hello there,

I have changed the DataStore location and moved into another SQL server. How to edit MF20.dsn file and type-in the new server name?
When I go into C:\Program Files (x86)\Citrix\Independent Management Architecture and open MF20.dsn in Notepad I get the following screen: I have replaced the account name with xxxx.
Should I type-in the new SQL Serve name in the Server line below?

[ODBC]
DRIVER=SQL Server
DATABASE=XA65DS
APP=Citrix IMA
UID=svc_<xxxxxx>
SERVER=XA65DS,1433
Trusted_Connection=Yes

Please advise. And also if there are any other place I need to change.

Thanks and Regards
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Goto ODBC -> File DSN -> Browse c:\\IMA\mf20 configure odbc settings then copy same file to other servers and perform the following command

\\servername\c$\Program Files (x86)\Citrix\Independent Management Architecture
C:\Program Files (x86)\Citrix\Independent Management Architecture
dsmaint config /user:ysername /pwd:password /dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn"

---------------------------------------------------------------------

\\servername\c$\Program Files (x86)\Citrix\Independent Management Architecture
dsmaint config /user:usernamer /pwd:password /dsn:"C:\Program Files\Citrix\Independent Management Architecture\MF20.dsn"
scr.jpg
Citrix Technology Professional - Fellow
Top Expert 2010
Commented:
the 1433 is not necessary.  I prefer to include the domain part in the UID line.

[ODBC]
DRIVER=SQL Server
DATABASE=XA65DS
APP=Citrix IMA
UID=domain\svc_<xxxxxx>
SERVER=XA65DS
Trusted_Connection=Yes


Once you have made your changes on the first XA servers (say XA651):

open a command prompt as administrator
net stop imaservice
dsmaint config /user:domain\svc_<xxxxxx> /pwd:password /dsn:"c:\program files (x86)\citrix\independent management architecture\mf20.dsn"
net start imaservice

sc \\%computername% query imaservice

Make sure the STATE says RUNNING

Now copy the MF20.dsn file from XA651 to another server and repeat the process.

It might help to create a batch file  with the four lines in it to keep you from typing so much (and reduce errors).

Author

Commented:
The new sql server name should be added in the line SERVER.

SERVER=XA65DS

Is this correct?
Carl WebsterCitrix Technology Professional - Fellow
Top Expert 2010

Commented:
Server is the SQL server name

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial