Update Citrix Farm Database Location

Hey Guys - I know very little about Citrix and need to update the database location used by a MetaFrame XP farm.

Basically, the existing server is being decomm'd and the new database is being moved from a Windows 2000\SQL 2000 instance to Windows 2003\SQL 2005.

LVL 23
Justin DurrantSr. Engineer - Windows Server/VirtualizationAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

In the Program Files\Citrix folder you should see a file called MF20.dsn.  If you open this with the ODBC/Data Sources tool in Admin Tools you should be able to walk through it and see the SQL server it is using.  Perhaps it is using access though?  First you should open this in notepad and see if the driver it calls is access or SQL.  
Now, once you know what and where, you need the how for migrating the DS.  


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Justin DurrantSr. Engineer - Windows Server/VirtualizationAuthor Commented:
Thanks man!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.