SQL Server 2005 Configuration for Resource Manager Summary Database

RoyATokeshi
July 27, 2006 10:59 am

Citrix states in their article: CTX110534

Document ID: CTX110534, Created on: Jul 25, 2006, Updated: Jul 26, 2006

Products: Citrix Presentation Server 4.0 for Microsoft Windows 2003

Symptoms

When using SQL Server 2005 for a summary database, the Summary Database tab within the Citrix Management Console displays the following:

“Database Connection Server not configured
Database not configured”

The log might include the following error message:

“Source [Microsoft OLE DB Provider for ODBC Drivers].

Description [[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'LU_APPNAME' in the database.].
11 July 2006 15:22:40 - System - Failed to create summary database.
11 July 2006 15:22:54 - System - Error 0x80040E14.

However, when testing the configuration everything checks out fine.

Cause

Currently, Citrix Engineering has only verified the usage of the SQL 2005 Database as the Independent Management Architecture (IMA) data store. Further testing, including migrations from one database to another, will be needed to fully support this database version. This version of the SQL database will be fully tested and supported for the next release of Citrix Presentation Server.

Workaround

Perform the following procedure:

Launch SQL Server Management Studio.
Create a new database.
Right-click the database and select Properties.
Go to Options.
Set the compatibility mode to SQL Server 2000 (80) and click OK.
Configure the user to be used to access:
Right-click Logins and select new login.
Select either SQL or NT authentication.
Note: You might want to set a default database as well.
Click user mappings and select the database you want to use.
Select db_owner.
Click OK.
Proceed to configure the Presentation Server System Data Source Name (DSN) file (make sure the file name is rmsummarydatabase all in lower case).
Configure the summary database within the Citrix Management Console.



Primary links

Custom Search

User login

Who's new

  • Choodogek
  • zepsleltpap
  • layersepavy
  • moneytome12
  • maczugaher

Who's online

There are currently 0 users and 4 guests online.

KrissysCorner.com RuthSwensonLaw.com CreativeLizardProductions.com

DISCLAIMER:

None of this has anything to do with us, someone else is responsible for the entire thing, and we have no idea who or why. We do not know anything about it. It may be alien life forms for all we know: we haven't a clue. You cannot blame us for anything that may result from your visit. That was entirely your own personal choice, made by you of your own volition, and without our knowledge. We do not, after all, have any control over you and cannot by any stretch of the imagination be expected to accept or acknowledge, be it legally or morally, any accountability for decisions made by you on an independent basis, utilizing your own free will, and without our intervention. We are therefore in no way, shape, or form answerable to anyone for any consequences arising from the aforementioned or indeed any other actions, similar or otherwise, because it was not us that did, or did not do anything. It is not even remotely our fault, and we are in no way prepared or willing to accept any liability, not even slightly, ever. We are, in fact completely and utterly blameless, in that it is definitely not our concern, and no blame can possibly be laid at our doorstep, even if we had one, the possession of which we hereby reserve as being entirely our own free choice. The onus is not on us at all, and furthermore, never has been. The entire matter is wholly beyond our control, and completely out of our hands, each of which are washed scrupulously clean of the whole business. We are not accountable for anything at all, and we hereby categorically deny all responsibility for all that has ever, or will ever happen. Our innocence is therefore wholly beyond doubt and absolutely unimpeachable, and so cannot, under even the remotest or unlikeliest circumstances, be brought into question. By clicking either on a link on this site, clicking on a link that leads to this site, or by arriving at this site by natural or supernatural means, you are in effect accepting responsibility for the fact that it is all entirely your own fault, down to the most miniscule detail, and that you are wholly accountable for whatever outcome may arise as a consequence of the aforementioned action or actions insofar as they were undertaken personally by you on an entirely voluntary basis and without any persuasion, coercion or influence from any party or parties other than yourself. Don't come sniveling to us, we are only figments of your imagination. I also agree that if I am ever with a contributor to this website during mealtimes I agree to pay for any super-sizing of their meal, or at least a nice dessert or one of those foo-foo drinks with an umbrella or a monkey. By admitting to have seen the worthless spineless drivel on this website (also known as content)

I Agree Wholeheartedly and Without Reservation to the above. (Except maybe for that part about the monkey.)

All Your Base Are Belong To Us.

Soylent Green Is People!

Never make a bet with a Sicilian when Death is on the Line!

No. Really, I do agree.