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
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
Do more with
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
\\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
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).
[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).
Premium Content
You need an Expert Office subscription to comment.Start Free Trial