Brian Madden Logo
Your independent source for application and desktop virtualization.
Discussion Forums » Tech Support Forums » Citrix XenApp / Presentation Server » Moved SQL Datastore all but three servers now wont connect
Marketplace

advertisement

Moved SQL Datastore all but three servers now wont connect, in the Citrix XenApp / Presentation Server forum on BrianMadden.com

rated by 0 users
Not Answered This post has 0 verified answers | 5 Replies | 0 Followers

Not Ranked
Points 270
Jason Taberner posted on 10-06-2008 2:11 PM
We have a Citrix Presentation 4 windows 2003 Citrix farm of about 120 servers. I have moved our datastore over to a new SQL server with a different name. I wrote script to copy the new DSN file to all the Citrix servers and to do a dsmaint on them to point to the new Datastore. All the servers have connected to the new datastore all except three servers? I have tried the following, recreated the LHC, uninstalled Citrix off one of them and tried to reinstall it. I tried a chfarm this did not work on one of them with no look. They dont seem to be able to connect to the DSN. Tried to setup a datasource in ODBC settings on the server, no luck. However I can still get them to connect to the original copy of the Datasource on the original SQL server ?
I've tried running DScheck /Clean no change. I have also renamed the server that I had uninstalled Citrix to see if the issue is with the servername that was being use no Luck anyideas other than a full rebuild.

All Replies

Top 10 Contributor
Points 14,899
Reply
Alan Osborne replied on 10-07-2008 12:14 AM
Hi,

It sounds like the three problem servers may be setup for indirect mode. Have a look at this reg key:

HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\IMA

If there is a PSServer value and the DatabaseDriver value is empty, then the server is using indirect mode.



Alan Osborne
President (MCSE, CCNA, VCP, CCA)
VCIT Consulting - Citrix/Terminal Services Remote Desktop Solutions for SMB
p: 604-288-7325
c: 778-836-8025
web: http://www.vcit.ca
blog: http://www.vcit.ca/wordpress

  • | Post Points: 5
Not Ranked
Points 20
Reply
Vince M replied on 10-07-2008 4:28 AM
Is it possible your authentication credentials on the last few machines were different for some reason?
  • | Post Points: 20
Not Ranked
Points 270
Reply
Jason Taberner replied on 10-07-2008 6:19 AM
SQL database it set to use SQL authentication the user name and password check out okay. I

checked the registry settings advised from Alan see below

HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\IMA

PSServer value ********NO SUCH key *****
DatabaseDriver = Imasql.dll

As I say I can connect to the original datastore through ODBC datasources ?

  • | Post Points: 5
Top 10 Contributor
Points 14,899
Reply
Alan Osborne replied on 10-08-2008 3:23 AM
Hi,

These servers are definitely setup to use a direct mode connection to the SQL server. You have copied the same DSN file to all servers, so the DSN should be fine. I would suspect some sort of network issue or perhaps a DNS issue.

What happens if you manually create a file DSN in the ODBC utility and use the TEST button - is it successful?

Can you telnet to the SQL server from one of these problem servers:

telnet 1433

Alan Osborne
President (MCSE, CCNA, VCP, CCA)
VCIT Consulting - Citrix/Terminal Services Remote Desktop Solutions for SMB
p: 604-288-7325
c: 778-836-8025
web: http://www.vcit.ca
blog: http://www.vcit.ca/wordpress

  • | Post Points: 5
Top 25 Contributor
Points 13,865
Reply
hans straat replied on 10-08-2008 7:46 AM
did you try dsmaint config /user:domain\username /pwd:password /dns:path to mf20.dns
if you use a sql account skip the domain part.
worste case scenario would still be a full rebuild of your machine.

Hans Straat , The Netherlands
CEO www.datacrash.net

  • | Post Points: 5
Page 1 of 1 (6 items) | RSS
Copyright © 1997-2008 The Brian Madden Company, LLC | Disclosures | Privacy | Terms of Use | Contact Info