Citrix Xenapp 6.5 Change configuration parameters used to connect to the data store

Hi

I've got a new Xenapp 6.5 farm that is in production.  Because I had to rush install this environment in two days, I didn't have any time to plan so I used my user account as the account that all the servers in the farm connect to the datastore.

I need to change that now.  So from the web server I ran:

dsmaint config /user:ABCnetwork\administrator /pwd:Passw0rd101
/dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn"

But got an error:

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 previous configuration.
Unable to change configuration settings.
Please verify parameters and data source.

Does this need to be done on the datastore server first and then all servers in the farm or is there a way to change this as a global setting?

Please help me get this changed.  Thank you.

Tony
tonyjoewalkerAsked:
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.

CoralonCommented:
1. Did you grant permissions on the database first?  (Dumb question, but an easy one to miss.
2. Try creating a new DSN file, and then use dsmaint to point to that.

It has to be done on each server, and as you surmised, I'd start with the ZDC first, and then get the rest as quickly as possible.

Coralon
0
tonyjoewalkerAuthor Commented:
Hi

Yes, the Service Account is a admin of the database.  So, just create a text file called mf21.dsn and run the command:

dsmaint config /user:ABCnetwork\administrator /pwd:Passw0rd101
/dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf21.dsn"

?

I also missed the step that said to stop the IMA service first.  Is it worth trying to stop the IMA, then run the same command as before, starting on the DS server?

Thanks!

Tony
0
CoralonCommented:
Yes, you have to stop IMA to use dsmaint :-)

You'd copy your mf20.dsn to mf21.dsn with your changes.  

net stop imaservice
dsmaint config... (you've got the syntax)
net start imaservice

That should do it for you.. I've done something similar in the past before :-)

Coralon
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

tonyjoewalkerAuthor Commented:
Hi

I followed all those steps and I am still getting the error:

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.

...later at the bat cave... well, something did happen actually.  Not sure what but it boned my entire farm.  I created a new VM from an image and had to restart the app servers and then everything worked again.  whew.

I also tried IMAhelper.exe.  Wondering if that is what boned it???

Tony
0
CoralonCommented:
I've never even heard of imahelper.exe?  

Have you tried running a dscheck against your database to make sure it's consistent?  Could be a corrupted database.

Coralon
0
tonyjoewalkerAuthor Commented:
0
tonyjoewalkerAuthor Commented:
Do you have any other ideas for getting the account the farm is running under changed?  Thank you.
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.