Link to home
Start Free TrialLog in
Avatar of Glenn Stearns
Glenn StearnsFlag for United States of America

asked on

ProClarity Administration Tool Login Problem

Running SQL Server 2005 Enterprise and Windows Server 2003 R2 Enterprise, both with latest service packs installed.
Installed SharePoint Server 2007 and PerformancePoint Server 2007.
Installed ProClarity Analytics Server 6.3. Have not yet installed the other ProClarity modules.
All these programs are running on the same server - an HP ProLiant 380DL - with all latest HP server software installed. This is a BI development server, so I need all these BI apps running on the same machine. When it is decided later to deploy these BI tools, separate servers will be used - but for now, this is a lab/test environment only.

Look at the attachment.  You can see from the screenprint that the database is created on the SQL server and that the user name and password have been created. When I try to log in on the Specify Access Credentials window using that name and password, it will not accept it, gives no error message, and re-displays the window as you see it on the screenprint.  I'm not sure the ProClarity Analytics Server is running, but don't know how to verify this.  The PAS database does appear in SQL Server Management Studio under the host name DAHLONEGA, but I do not see any server name in the list of hosts to register named ProClarity.

A copy of the ProClarity Diagnostic Report is also included in the attachment.

How do I get past this point so that I can continue to install ProClarity?

ProClarity-Screens.pdf
Avatar of Jim P.
Jim P.
Flag of United States of America image

No ProClarity experience whatsoever -- so many grains of salt.

This appears that it is an issue with the web server portion of the setup, not SQL.

The way to rule out the SQL Server is fire up the SQL Server Management Studio.

Put DAHLONEGA in the Server Name; select SQL Authentication and then use the PAS as the login with the associated password.

If you can browse to the ProClarity_PAS db, then the SQL isn't the primary issue. If you can get logged in, but can't get to the DB (and do DML (update/inster/delete) and/or DDL (modify objects)) then it could be a security issue.

If it isn't a SQL issue, we can see about getting this rezoned with some web zones.
Avatar of Glenn Stearns

ASKER

I can access the ProClarity database on the Dahlonega server and open any of the tables, just cannot log in to the ProClarity Analytics Administration Tool.
ASKER CERTIFIED SOLUTION
Avatar of Jim P.
Jim P.
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, I posted this on MS Technet at the blog site you provided. Perhaps they can help me out.

Thanks for the referral!