[THIN] Re: XenApp4.5 SQL Database Migrations
- From: "Jeremy Saunders" <Jeremy.Saunders@xxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Tue, 20 Jul 2010 17:44:36 +1000
No issues at all Alan. Although I have found in some of the larger
enterprise environments that I have to increase the Kerberos token size
on the XenApp servers.
So I script it as per the following...
----start script----
@ECHO OFF
:: Increase the MaxTokenSize. This is required in larger organisations
when communicating with SQL 2008
:: To be applied on the Citrix Servers. A registry parameter is
available to increase the Kerberos token size.
:: For example, increasing the token size to 65 KB allows a user to be
present in more than 900 groups.
:: Because of the associated SID information, this number may vary. The
default value for MaxTokenSize is 12000
:: decimal. It is recommended that you set this value to 65535 decimal,
FFFF hexadecimal. If you set this value
:: incorrectly to 65535 hexadecimal (an extremely large value) Kerberos
authentication operations may fail, and
:: programs may return errors. Refer to the following articles for
further information:
:: - http://support.microsoft.com/kb/263693
:: - http://www.mssqltips.com/tip.asp?tip=1557
:: Note: After you set the value and the computer is updated, restart
the computer
SetLocal
SET KEY=HKLM\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters
REG ADD "%KEY%" /v MaxTokenSize /d 65535 /t REG_DWORD /f
EndLocal
Exit /b 0
----end script----
The best way to migrate the database between different versions of SQL
is to use the DSMAINT MIGRATE command line from a XenApp server.
Cheers,
Jeremy.
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of alan tropper
Sent: Tuesday, 20 July 2010 3:16 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] XenApp4.5 SQL Database Migrations
Hi All,
Just wanted some advice on a migration plan as looking to decom our SQL
2000 cluster servers and replace them with SQL 2008, firstly does anyone
know of any issues with support for XenApp4.5 R05 Win2003 servers on
SQL2008?
The plan would be to move both my Resource Manager Summary DB and the
Data Store so any advice or hazards I may come across would be greatly
appreciated.
Thanks in advance.
Alan
#####################################################################################
Confidentiality and Privilege Notice
This document is intended solely for the named addressee. The information
contained in the pages is confidential and contains legally privileged
information. If you are not the addressee indicated in this message (or
responsible for delivery of the message to such person), you may not copy or
deliver this message to anyone, and you should destroy this message and kindly
notify the sender by reply email. Confidentiality and legal privilege are not
waived or lost by reason of mistaken delivery to you.
#####################################################################################
Other related posts:
