You are currently browsing the monthly archive for April 2009.
To setup the Summary Database I followed the steps below;
In SQL Server Management Studio I created a new database (e.g citrix_summary) and configured/created a new SQL account (e.g. CitrixSummary) and mapped the account to the citrix_summary database as the db_owner. Note: You might want to set a default database as well.
I also found that I had to remove the ‘user must change password at next login’ check.
On the PS4.0 server, select data sources ODBC in admin tools. Create a new System Data Source using SQL server driver called rmsummarydatabase (make sure to have it in lower case – RMSummaryDatabase did not work for me). Check connections.
In the Pres Server Console, configure the summary database in resource manager. Enter the server you configured the ODBC setting on, and enter in the SQL user and password created on the SQL server (in my case CitrixSummary). Run a test to see if the configuration works.
