Re: Unable to register OLAP DB on SQL Analysis Manager
- From: "Dave Wickert [MSFT]" <dwickert@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Apr 2005 08:47:10 -0700
So your situation was caused by untrusted domains (and through firewalls)
which isn't supported.
DSO requires trusted connections (by having matching uid/pwd you are using
the backdoor). This ends up causing a lot of network traffic authentication
to occur which doesn't happen if you have a domain account. Don't be
surprised if 1) there is a lot more network traffic between client and
server; and 2) you are more suseptable to network issues, timeouts,
disconnects, etc.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexander Hirthe" <AlexanderHirthe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:FF27CF53-C725-4671-9A60-7F19434F3030@xxxxxxxxxxxxxxxx
> Hello AKing,
>
> I found a soloution:
> - the Analysis Manager uses Netbios Fileshares, so you must be able to
> connect ot \\servername, check this in your firewall/DNS Settings
> - I wasn't able to connect until I created a local user on the server,
with
> the same username and passwort like my domain account.
>
> Alex
>
>
> "AKing" wrote:
>
> > Hi,
> >
> > I am trying to connect to an OLAP database using SQL Analysis Services
> > Manager over a Cisco VPN connection.
> >
> > When I attempt this I get the follwoing error:
> > Errors occurred. Cannot open connection to Analysis server Error in data
> > [Possible data corruption]
> >
> > I have confirmed that Service Pack 3 is installed, but I am not sure
what to
> > do from here.
> >
> > Any help would be greatly appreciated!
> >
> > Cheers!
> >
.
- Follow-Ups:
- References:
- Unable to register OLAP DB on SQL Analysis Manager
- From: AKing
- RE: Unable to register OLAP DB on SQL Analysis Manager
- From: Alexander Hirthe
- Unable to register OLAP DB on SQL Analysis Manager
- Prev by Date: Re: Calculated member / set depending on two dimensions
- Next by Date: Re: problem to display calculated dimension members in pivot table
- Previous by thread: RE: Unable to register OLAP DB on SQL Analysis Manager
- Next by thread: Re: Unable to register OLAP DB on SQL Analysis Manager
- Index(es):
Relevant Pages
|