Mega Search
23.2 Million


Sign Up

Make a donation  
Unable to register OLAP DB on SQL Analysis Manager  
News Group: microsoft.public.sqlserver.olap

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!


Vote for best question.
Score: 0  # Vote:  0
Date Posted: 20-Apr-2005, at 12:52 PM EST
From: =?Utf-8?B?QUtpbmc=?=
 
RE: Unable to register OLAP DB on SQL Analysis Manager  
News Group: microsoft.public.sqlserver.olap
Hello,

we have the same problem here, are you current with your hotfixes? A 
Developer installed it some weeks ago, and everything works fine.
I installed a new server yesterday and the manager on my Workstation today, 
and I can't connect at all :-(
I thought it could be a problem with the latest hotfixes? 

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

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 21-Apr-2005, at 2:59 AM EST
From: =?Utf-8?B?QWxleGFuZGVyIEhpcnRoZQ==?
 
RE: Unable to register OLAP DB on SQL Analysis Manager  
News Group: microsoft.public.sqlserver.olap
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!
> 

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 22-Apr-2005, at 4:54 AM EST
From: =?Utf-8?B?QWxleGFuZGVyIEhpcnRoZQ==?
 
RE: Unable to register OLAP DB on SQL Analysis Manager  
News Group: microsoft.public.sqlserver.olap
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@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.

"Alexander Hirthe"  wrote in
message news:FF27CF53-C725-4671-9A60-7F19434F3030@microsoft.com...
> 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!
> >



Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 22-Apr-2005, at 8:47 AM EST
From: Dave Wickert [MSFT]
 
RE: Unable to register OLAP DB on SQL Analysis Manager  
News Group: microsoft.public.sqlserver.olap
@Alex
I was also able to register when adding the local workstation account to the 
OLAP server.  Thank you for your reply.

@Dave
I understand that this is an unsupported method and may cause connectivity 
issues.

"Dave Wickert [MSFT]" wrote:

> 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@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.
> 
> "Alexander Hirthe"  wrote in
> message news:FF27CF53-C725-4671-9A60-7F19434F3030@microsoft.com...
> > 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!
> > >
> 
> 
> 

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 23-Apr-2005, at 8:29 AM EST
From: =?Utf-8?B?QUtpbmc=?=