VPN - Potfolio Analyzer

E

Eric

I am just a contractor, so I don't have specific
information. But here is what I know. We are runnning in a
workgoup environment, which has forced me to put users
that need to access the cube on the sql machine, and I
have to match passwords. When I login from home I do get a
windows authentication popup. Can ou tell me how you have
fixed this before and I can try it? Or if you can tell me
what I need to ask the network admin.
Thanks
Eric
-----Original Message-----
Hi Eric,

Can you post some more details as to how exactly your network is set up?


--
Regards,
Nico Oosthuysen



.
Click to expand...
..
 
G

Guest

Excerpt from the MS 2003 Configuration Guide
(http://go.microsoft.com/fwlink/?LinkID=20235):
Analysis Services
Computers running Project Server, SQL Server, and Analysis
Services must all be in the same domain in order to
provide full Portfolio Analyzer functionality. Users
attempting to create Portfolio Analyzer views and access
the OLAP cube from a non-trusted domain are denied access
to the OLAP cube. Authentication to the OLAP cube requires
Windows authentication. If the user's local credentials
are not recognized, as is the case when users access
Portfolio Analyzer from a non-trusted domain, access to
the OLAP cube will be denied. If you want to allow users
from non-trusted domains access to Portfolio Analyzer,
they must be explicitly granted permission to access the
computers running SQL Server and Analysis Services as
Windows user accounts.
If a user in a non-trusted domain attempts to access
Portfolio Analyzer from Project Web Access, he or she will
receive the error "Unable to access the Microsoft
Portfolio Analyzer OLAP Cube" unless the user is able to
specify a Windows user account to the Analysis
Services server. There are two ways to pass the OLAP
administrator account:
.. Create a local Windows user account that is granted
permission to view OLAP cube
data. Use this account to enable access to Portfolio
Analyzer for users in a non-trusted
domain. This is not an ideal solution, because it allows
access to computers running
SQL Server and Analysis Services and should be treated as
a potential security issue.
.. Configure Portfolio Analyzer so that it is accessible
using HTTP (this will require using SQL Server 2000
Enterprise Edition), and then enable SSL. There are two
options when using this method:
.. Allow a user to log on with a set of credentials created
at the computer running Analysis Services when he or she
is asked to enter a user name and password.
.. Embed the user name and password in the connection
string when creating the view (be sure to clear the Show
Toolbar option to hide the connection string).
Using Hypertext Transfer Protocol Secure (HTTPS) is the
most secure option.

Hope this helps you...

/j
 
E

Eric

I do log in through a windows login screen but no dice.
How do you do the bottom piece of this?
Thanks
Eric
 
G

Gary L. Chefetz [MVP]

Eric:

Do you have Enterprise Edition of SQL? Without it, you can't do the bottom
half. Most folks don't have Enterprise edition because of the cost. If you
do have Enterprise edition, do a search on the KB on the topic. There's an
article on exposing analysis services via http.
 
Top