Can Analysis Services be used by application service providers?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I currently have an application deployed as a service over the internet
(can't say ASP anymore or people will think I'm talking web servers) using
sql authentication and it's been working great. Now it's time to deploy an
analysis portion of the application and I've hit a dead end. My customers
are not on our domain, they are from hundreds of different companies around
the country so windows authentication seems like it is out. Is SSAS only
intended for internal company use on windows computers? No linux or mac
clients or external access (unless I enable anonymous access which is not an
option)?

Is there any way for me to generate a kerberos authentication token on the
client and pass it on to the server to impersonate a windows account? I
know where is some form of windows account impersonation using IIS but we
have no use for IIS otherwise and as far as I know using IIS limits us to
using XMLA for our queries and the current display components we have been
working with are not XMLA enabled. Am I better off finding a non-Microsoft
solution? I have to admit we are a ways down this path and I was surprised
to realize that this appears to be a windows client only solution, when
Microsoft has done such a good job with Sql Server in the past of making it
competitive with Oracle and DB2 for all clients, not just windows clients on
the same domain. Have they just dropped the ball with SSAS and decided not
to compete for clients unless they are on the same domain as the Sql Server?

Any help appreciated,

Shane Delmore


.

Relevant Pages

  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Need help configuring Wireless Connection profile
    ... and I can only use the intel OR windows utility, not both at the same time. ... Windows authentication for all users,4129,LRG\ryanv,4149,Wireless WPA2 ... SMALL BUSINESS SERVER: ... STEP #1 Install Certificate Services ...
    (microsoft.public.windowsxp.general)
  • Re: EAP-TLS with windows CE
    ... The AP was sending out an Identity Request every second, ... request to the identification server. ... When the server asks the Windows CE device to identify itself, ... I could easily steal your authentication information. ...
    (microsoft.public.windowsce.platbuilder)
  • Re: Users Cant Access Documents on Server
    ... my computer to the network on the server. ... Connection Wizard none of the computers were listed. ... The Mac clients can not communicate with the server box. ... > Error Messages When You Open or Copy Network Files on Windows XP SP1 ...
    (microsoft.public.windows.server.sbs)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)