Solved

ProClarity Administration Tool Login Problem

Posted on 2009-07-14
4
1,170 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:Glenn Stearns
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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:Glenn Stearns
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:Glenn Stearns
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

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…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

726 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