Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1896
  • 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
Independent Software Vendors: 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!

 
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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