[THIN] Re: XenApp4.5 SQL Database Migrations
- From: "alan tropper" <alan.tropper@xxxxxxxxxxxxx>
- To: "thin@xxxxxxxxxxxxx" <thin@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2010 07:51:51 +0800
Excellent info.just what I was after!!
Thanks Jeremy :-)
________________________________
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of
Jeremy Saunders
Sent: Tuesday, 20 July 2010 3:45 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: XenApp4.5 SQL Database Migrations
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:
