attempting to migrate citrix database to a new server

I used instructions for the process I found here http://terenceluk.blogspot.com/2012/11/migrating-citrix-xenapp-65-data-store.html ..Im attempting to migrate our citrix database to another server. 2005 SQL express to 2008 SQL server. I was able to backup the DB and restore it on the new server with no isssues but when I ran the dsmaint config /dsn "file location of MF20.dsn" I get the error below
Attempting to connect to the data store with new configuration settings.
Failed to connect to the data store. The settings will be reverted to the previo
us configuration.
Unable to change configuration settings.
Please verify parameters and data source.
I read the link the article states to follow if there are any issues with that command but I dont think the solution applied to my situation.

I have attached the MF20.dsn file from a citrix server I have already made 1 change to it
SERVER=FS01\SQLEXPRESS     TO           SERVER=FS02\SQL

Any ideas would be appreciated
bankadminAsked:
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.

Carl WebsterCommented:
0
Dirk KotteSECommented:
often the problem is not enough rights ar the datadase-server.

i prefer the dsmaint migrate method.
- create a second dsn "mf20-new.dsn" with new connection settings.
- create an empty database (or table)  at the new sql-server
- provide enough rights for the citrix-service-account
use "dsmaint migrate to copy the database content to the new server:
dsmaint migrate /srcdsn:dsnfile /srcuser:user /srcpwd:password /dstdsn:dsnfile /dstuser:user /dstpwd:password
dsmaint migrate provides good, cleartext errormessages.
if the migrate proccess is successfull the dsmaint config has no problem mostly.
0
bankadminAuthor Commented:
Carl- With our current setup there is no ODBC connections will I have to create one since Im moving from sqlexpress to a sql?

dkotte- Thanks for the suggestion I will follow up with that way of migrating if I cant get the way I attempted it to work.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Carl WebsterCommented:
An ODBC connection allows you to create or test the mf20.dsn file (or the name you used if you renamed the file).
0
bankadminAuthor Commented:
I ended up using IMA helper to help with the process I was still having issues then realized the IMA service was still running when I was try the dsmaint process got that shutdown and it worked.
0

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
bankadminAuthor Commented:
Thank you for the help it always helps the process even if I dont do exactly what has been posted..
0
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
Citrix

From novice to tech pro — start learning today.

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.