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