[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8622
  • Last Modified:

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

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
0
goprasad
Asked:
goprasad
  • 2
2 Solutions
 
Sekar ChinnakannuSenior EngineerCommented:
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
0
 
Carl WebsterCommented:
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).
0
 
goprasadAuthor Commented:
The new sql server name should be added in the line SERVER.

SERVER=XA65DS

Is this correct?
0
 
Carl WebsterCommented:
Server is the SQL server name
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now