Solved

Where is my Citrix db?

Posted on 2009-05-20
8
1,877 Views
Last Modified: 2012-08-13
Presentation Server 4.5, Windows Server 2003 32 and 64, SQL Server 2005

I wanted to change the server on which my Citrix FARM DB is sitting, but I can't find the database on the server.
After some reading I figured out where the information was sitting, in mf20.dsn.  Here's the weird thing : I don't have a "Database=" entry in my dsn file!
I know that the DS is on that server, because if I put the server down, Presentation Server can't connect to the datastore.

Here is the mf20.dsn :

[ODBC]
DRIVER=SQL Server
UID=sa
WSID=S1CTX01
APP=Citrix IMA
SERVER=V1SQL01

Any ideas?!  Also, when I find it, I intend to move the DB to an SQL 2000 server instead of 2005,  is there anything I should be worried about?
0
Comment
Question by:dunnoh
  • 4
  • 2
  • 2
8 Comments
 
LVL 8

Expert Comment

by:zoubi77
ID: 24438667
First things first.

Check on your SQL2005 server (V1SQL01) if there is MF20.dsn database present. Check ALL the instances, specially if there is CITRIX_METAFRAME instance present.

Then try to recreate DNS file. Go to COntrol Panel > ODBC > browse to your MF20.dsn file > change..see if all the data is correctly entered. At the end click 'test connection'. If you get errors, post it here.


0
 
LVL 8

Expert Comment

by:zoubi77
ID: 24438731
For moving database. You can move, but you must change dsn file on ALL your citrix servers. If credentials for 'sa' user are the same, than you should only change 'server' variable to point to new server. Now it states SERVER=V1SQL01, you should change it to SERVER=new server
0
 
LVL 8

Accepted Solution

by:
LKaushal earned 250 total points
ID: 24439249
0
 
LVL 1

Author Comment

by:dunnoh
ID: 24441157
Oh god, Citrix IMA is connected to the Master database.
Now what do I do?!
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 1

Author Comment

by:dunnoh
ID: 24441196
Actually, I had new elements and found this other thread in here :
http://www.experts-exchange.com/Software/System_Utilities/Remote_Access/Citrix/Q_22812497.html?sfQueryTermInfo=1+10+citrix+databas+master

If doing that fixes my problem, I'll award points to LKaushal, as the second link he gave me pointed me in the right direction.

0
 
LVL 1

Author Comment

by:dunnoh
ID: 24441252
Ok after reading more about that other solution I found, I won't be able to do it.
I can't afford to lose the farm data, so I need to move the database first.
But I obviously can't move the master database to another server...
any ideas?
0
 
LVL 8

Expert Comment

by:LKaushal
ID: 24444864
Try reading one more pdf => http://support.citrix.com/article/ctx107597

This is the best one.
0
 
LVL 1

Author Comment

by:dunnoh
ID: 24547434
I ended up backing up the 2005 master db, restoring it with a different name.
I then created a new 2000 db on my other server, scripted the restored master with 2000 compatibility, ran it on the blank DB and migrated the data using the sql management console.

The rest was just a regular database move with the mf20.dsn and dsmaint config.

I still have master data in that database but I don't care all that much since the db is pretty small anyways.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

#Citrix #Citrix Policies #XenDesktop #VDI #POC #Citrix Univeral Printer Driver #Citrix UPD
Citrix XenDesktop 7.6 Citrix Policies Audio
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now