setting up Citrix on SQL 2000 cluster

[sajmo]

I am in the process of redesigning Citrix infrastructure; I just wanted to know has anyone managed to set-up Citrix on SQL 2000 cluster, if so what are the steps involved. I would really appreciate any help.

Many thanks

 

[victorv]

hi,
I don't see the "link" between SQL Cluster and Metaframe:
the only motivation that I can see is that:
you have only 2 servers in your farm.

The right thing is to put Data Store on this architecture,
use the Cluster as file+printer server but, for
Metaframe server, I should use one or more different
servers.
Also for DC I prefere don't use Cluster.

I know, Windows 2k Server is not free, but if you have
budget for SQL Enterprise Edition, I suggest to keep
this important tasks separated on machines

bye

 

[JeffHicks]

I'm not sure if it was clear in the previous reply, but under no circumstance would I install Citrix on a server that also is running SQL Server, much less one which is clustered. If instead of that, you were wondering about the data store being stored on a SQL cluster, although I have not done this, it should not differ from any normal data store configuration. A properly setup SQL cluster should act the same as a single server, and thus you would point the datastore dsn to the SQL cluster, the same way you would to a single SQL server.

 

[sajmo]

I should have made my self more clear, it is the Data Store that I am trying place on the SQL Cluster.
I have tried to building the Citrix box with the Data Store on the SQL Cluster but as soon as I configure the Data Store to point at the Cluster the New Citrix box just blue screens on me.
I am using windows 2000 server with SP2, which is a member server in a domain.

Many Thanks

 

[JeffHicks]

That is very strange. I wonder if you built it on a non-clustered SQL server and moved it to the cluster if it would be OK. The IMA service connects to the Data Store via ODBC connection (a file dsn), so it should not care between a clustered or non-clustered environment. For testing/diagnosis purposes, can you create a dsn on the Citrix server and point it to the data base on the cluster? Test the connection and see if it is successful.

 

[CitrixEngineer]

BSODs tend to be caused by hardware drivers, especially Printers, Disk Controllers and NICs - are there any clues in the BSOD as to where the problem started? Anything in the Event Log?

Try doing the DSN test that Jeff suggests on another Citrix server (no need to make that the Data Collector - in fact, it may cause issues if you do).

Hope this helps

CitrixEngineer@yahoo.co.uk