Solved

ProClarity Administration Tool Login Problem

Posted on 2009-07-14
4
1,162 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:glennes
  • 2
  • 2
4 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 24851751
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.
0
 

Author Comment

by:glennes
ID: 24851907
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.
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 24851969
Then it sounds like an issue with the IIS.

Did you see this article by any chance:
---------------------------------------------------------------------------
ProClarity 6.3 SP2 (build 2217) Documenation
http://blogs.technet.com/proclarity/default.aspx?p=2
---------------------------------------------------------------------------

I know your are SQL05 and WinK3, but it maybe the same issue:
---------------------------------------------------------------------------
ProClarity 6.3 SP2 and Microsoft Office Sharepoint Services 2007 are not currently supported when running together on the same Microsoft Windows 2008 Server.
---------------------------------------------------------------------------
0
 

Author Comment

by:glennes
ID: 24852657
Thanks, I posted this on MS Technet at the blog site you provided. Perhaps they can help me out.

Thanks for the referral!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question