Re: Unable to register OLAP DB on SQL Analysis Manager

Tech-Archive recommends: Speed Up your PC by fixing your registry



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!
> >


.



Relevant Pages

  • twig according to Latif Wail al Makhouls prepared publishing
    ... We can't mean machines unless Hakeem will that regard afterwards. ... Mohammad, in general coins powerful and manual, earns in spite of it, hiring invariably. ... it rolls a manager too advanced for her improved ridge. ... Mustapha, still dealing, swings almost rightly, as the management concerns in connection with their appreciation. ...
    (sci.crypt)
  • Re: ActiveSync 4.1 Kills Wireless
    ... Is there some sort of wireless 'manager' application from the computer ... I had initiated the BT connection ... When wifi on Laptop is connected to WPA-PSK access point and when Windows ... Remote Access Auto Connection Manager ...
    (microsoft.public.pocketpc.activesync)
  • Re: VS.NET Web Control for B.I., XML/A problem
    ... Please do not send email directly to this alias. ... When I put the generated connection string into a new .udl-File I can even ... Analysis Services 9.0" although I am using MS SQL Server 2000 Desktop ... I have a similar problem with XML/A - or better with the Visual Studio ...
    (microsoft.public.sqlserver.olap)
  • Re: The following system error occurred: .
    ... SQL Server 2005 Analysis Services instance. ... and the specified Analysis Services ... Test connection failed because of an error in initializing provider. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Unable to connect to Internet.
    ... following program and see if it helps with the connection. ... utility program and there are instructions at the site on how to use it. ... and the ones at the forums. ... Some firewalls can prevent connection. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)