March 7, 2007 at 1:31 am
Does anyone have any experience of migrating and running the Citrix PS4 datastore on SQL2005? We have a plan to run the Datastore on a mirrored database. So far following the citrix white paper on this has failed!
I have so far moved the datastore to the SQL2005 server using the database copy gui - I have not even attempted to set up the mirroring.
I have:
changed the db to mixed mode authenication set up a new dsn on the presentation server using the native client,conections to the database work fine when performed manually, the citrix guys run the dsmaint command to switch to the SQL2005 server and that works, they can restart all of the citrix services - but when they try to use any of the citrix tools it fails to connect to the datastore. unfortunately the pop-up window just says that the connection failed! there is no diagnostic info.
March 12, 2007 at 8:00 am
This was removed by the editor as SPAM
March 12, 2007 at 8:46 am
Paul,
The most possible reason will be that some logins on the new server have different SIDs from the old server even if they have the same name. Make sure you can connect yourself when using logins the Citrix tools are using.
The second most possible reason is that TCP/IP may not be enabled. In 2005 it is disabled by default, you have to enable it using SQL Server 2005 Configuration Manager.Services may use Shared Memory to login while the tools may have a connection hardcoded that uses TCP/IP
Regards,Yelena Varsha
March 12, 2007 at 9:19 am
Yelena,
I migrated the Citrix datastore using backup and restore. I can connect on the local server using the Citrix login used by the citrix server in the server farm.
I can also set up a File DSN, using the SQL native Client, on the the Citrix server and that appears to connect successfully to remote database.
The surface area configuration tool for the instance holding the Citrix datastore also indicates that TCP/IP has been enabled to allow connections locally and remotely.
My preference is to use a named instance over the default instance, but I have tried both options to no avail!
but still no joy! any other ideas?
Thanks
Paul
March 12, 2007 at 9:41 am
Check if the firewall is open on port 1434 to browse between instances or configure DSN not to use "Dynamically determine port" I also will ask our Citrix admin who has 2005 as a database and he did configure mirroring too as he told me.
Regards,Yelena Varsha
March 12, 2007 at 10:06 am
how do I: "configure DSN not to use "Dynamically determine port" " ?
That option does not appear as an option when i create or configure the File DSN
March 12, 2007 at 12:56 pm
Paul,
This is under Client Configuration (a button) in Administrative Tools ->Data Sources and then selecting your data source under File DSN.
Client configuration points to the same Client Network Utility as you do Strat ->Run->Cliconfg and it is a machine-wide configuration, so if you change it in one place, it will change for all places including SQL Server Configuration manager, Native Client Configuration
Create an alias in Client Network Utility that uses TCP/IP and does not use Dynamically Determine Port and enter the port number that your server uses for TCP/IP. You may determine it by using Server Network utility on the server (for 2000) or SQL Server Configuration manager for 2005. Then use this alias as a server name for DSN.
I also talked to our Citrix admin, he did not have any issues connecting Citrix tools. He said that he did have to change the DSN to use Native Client because he uses Mirroring and the Native Client does let you to specify the Failover Partner for mirroring.
He says that if you are using Express Edition of SQL Server the instance names are different, there is something special about names when using Express Edition.
He also recommends to check the security log on the database server, something may be there.
Regards,Yelena Varsha
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply