• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1905
  • Last Modified:

Where is my Citrix db?

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
dunnoh
Asked:
dunnoh
  • 4
  • 2
  • 2
1 Solution
 
zoubi77Commented:
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
 
zoubi77Commented:
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
 
LKaushalCommented:
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
dunnohAuthor Commented:
Oh god, Citrix IMA is connected to the Master database.
Now what do I do?!
0
 
dunnohAuthor Commented:
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
 
dunnohAuthor Commented:
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
 
LKaushalCommented:
Try reading one more pdf => http://support.citrix.com/article/ctx107597

This is the best one.
0
 
dunnohAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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