Resource Manager Summary Database in PS 4.5 “Database inaccessible”

While setting up a PS 4.5 farm the other day and configuring the Resource Manager Summary database, I ran into an issue where after creating the DB on the SQL server and configuring the DSN to use Windows authentication rather than SQL authentication on the DB connection server, I was getting the error “Database inaccessible” when running the “Database Connection Server Test” in the CMC. After poking around the SQL logs I was able to figure out that the DB connection server was attempting to authenticate using the machine account of the DB connection server. Everything would work fine when using SQL authentication but not Windows authentication. After adding the machine account privelages on the SQL DB using domain\computer$, and leaving the credentials blank in the CMC, everything worked like it should. I thought this was odd at the time, but Citrix has posted a KB article detailing the known issue with 4.5 and the steps to resolve it yesterday at CTX113003

Advertisements

~ by mindsecure on May 15, 2007.

2 Responses to “Resource Manager Summary Database in PS 4.5 “Database inaccessible””

  1. Following the article allowed me to setup the Summary Database and reports ran fine from the PSC. But when I tried to generate reports from the AMC I got errors when attaching to the rmsummarydatabase. This is referenced in CTX108738 which references a MS Article http://msdn.microsoft.com/en-us/library/aa259618.aspx that has you change ownership on the tables using SQL Analyzer. This did not work for me so the final fix was to setup a local SQL account for the summary database instead of using a Windows Domain account.

  2. Excellent, what a website it is! This web site provides helpful data to us,
    keep it up.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: