Solved

ProClarity Administration Tool Login Problem

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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 gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

706 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

23 Experts available now in Live!

Get 1:1 Help Now