Solved

Where is my Citrix db?

Posted on 2009-05-20
8
1,894 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:dunnoh
ID: 24441157
Oh god, Citrix IMA is connected to the Master database.
Now what do I do?!
0
 
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Citrix XenDesktop 7.6 Citrix Policies Disable Peripherals
If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
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.

617 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