Solved

ProClarity Administration Tool Login Problem

Posted on 2009-07-14
4
1,160 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql query 12 67
sql calculate reminders 11 69
Query - which index being used? 2 47
SQL Agent Timeout 5 47
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now