Re: OLAP Client connectivity

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

From: Jim (Jim_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 12:51:02 -0700

Was finally able to login to OLAP from the client. The client no longer logs
into the Windows domain. They only pass their username/password to
applications.

We have a Windows 2003 server with OLAP, that would not accept usernames and
passwords from the domain and so what not allow connectivity from the client.
 Apparently there is now a direct connection that works.

"Jim" wrote:

> Was able to login to Windows 2003 server under the domain and was able to see
> the domain when adding users in SQL Server 2000. Tried to enter domain users
> into the OLAP Administrators group, but was unable to - the domain was not
> recognized. Is there are way to update the server user/groups to recognize
> domain users? (SQL Server was able to).
>
>
> "Dave Wickert [MSFT]" wrote:
>
> > See the Analysis Services Operations Guide in the section on Security
> > Administration
> > http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
> > --
> > Dave Wickert [MSFT]
> > dwickert@online.microsoft.com
> > Program Manager
> > BI SystemsTeam
> > SQL BI Product Unit (Analysis Services)
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Jim" <Jim@discussions.microsoft.com> wrote in message
> > news:248E7F61-C4B3-4497-AB3E-C0999BE4E254@microsoft.com...
> > > I'm going to be both administering and querying the server and your right,
> > > and the server is not in the domain. It sounds like the server needs to
> > be
> > > added to the domain. I'll give this a shot.
> > >
> > > "Dave Wickert [MSFT]" wrote:
> > >
> > > > Didn't you say in the first posting that the server wasn't in the
> > domain?
> > > > You must have a common trusted domain between the client and the server.
> > > > This is true for both querying and administration.
> > > > Are you trying to administer this server (using Analysis Manager) or are
> > you
> > > > going to be just querying this server?
> > > > --
> > > > Dave Wickert [MSFT]
> > > > dwickert@online.microsoft.com
> > > > Program Manager
> > > > BI SystemsTeam
> > > > SQL BI Product Unit (Analysis Services)
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "Jim" <Jim@discussions.microsoft.com> wrote in message
> > > > news:B72D4669-7C4F-479F-BAD4-FF89E16F83C8@microsoft.com...
> > > > > The exact error I'm getting is:
> > > > >
> > > > > "Errors occured whilte connecting to server. Cannot open
> > > > > connection to Analysis server 'mindset'. Error in data
> > > > > [possible data corruption] Do you still want to register
> > > > > this server?"
> > > > >
> > > > >
> > > > >
> > > > > "Jim" wrote:
> > > > >
> > > > > > Also, the client user was added to the OLAP administrator group and
> > > > service
> > > > > > pack 3 was installed on the client computer.
> > > > > >
> > > > > > "Jim" wrote:
> > > > > >
> > > > > > > I'm unable to connect through the OLAP client to the Server.
> > > > > > >
> > > > > > > The OLAP server is SQL Server 2000 in Windows 2003. The domain
> > > > network is
> > > > > > > Windows 2000 and the Windows 2003 server is not a part of the
> > domain.
> > > > > > >
> > > > > > > The client is Windows XP Professional with the client OLAP +
> > service
> > > > pack 3
> > > > > > > installed on it(Logging onto the Windows 2000 domain at boot up).
> > > > > > >
> > > > > > > The OLAP client is run on the client computer and an attempt is
> > made
> > > > to
> > > > > > > register the OLAP Server by entering the DNS name of the OLAP
> > server,
> > > > however
> > > > > > > the OLAP server is not recognized and an 'authentication' error
> > > > occurs.
> > > > > > >
> > > > > > > What is required for the client to connect to the OLAP Server?
> > > >
> > > >
> > > >
> >
> >
> >

Relevant Pages

  • Re: Cannot load databases; version may not be valid
    ... I've installed the PTS from SP4 on the client and doesn't help. ... The thing is that I can't even see the OLAP databases. ... But on the server itself works fine. ...
    (microsoft.public.sqlserver.olap)
  • Pass-through authentication from desktop to remote server
    ... I'm trying to set up some client workstations currently running XP to ... act as if they were thin clients connecting to SBS2003 server. ... prompted for username/password, they are immediately logged on to ... to mstsc, but again, this would happen on the user level GP rather ...
    (microsoft.public.windows.terminal_services)
  • Re: Pass-through authentication from desktop to remote server
    ... ThinClient Server is the best one. ... Type in their username/password and go straight to the TS. ... Windows Server - Terminal Services ... > I'm trying to set up some client workstations currently running XP to ...
    (microsoft.public.windows.terminal_services)
  • RE: No access to Analysis Services Database
    ... utilizes Pivot Table Service to communicate from the client to Analysis ... Created a catalog and cubes on a development server. ... Deleted the current OLAP db on production server. ...
    (microsoft.public.sqlserver.olap)
  • Re: IE prompts for username password when saving excel file opened
    ... challenge for username/password when required to authenticate -- it is up to ... the client to know how to satisfy that requirement without popping up the ... I'm having a problem with IIS server. ... it opens in IE and if I try save the document ...
    (microsoft.public.inetserver.iis.security)