|
Home > Archive > MS SQL Server OLAP > April 2005 > Unable to register OLAP DB on SQL Analysis Manager
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unable to register OLAP DB on SQL Analysis Manager
|
|
|
| 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!
| |
| Alexander Hirthe 2005-04-21, 7:23 am |
| 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!
>
| |
| Alexander Hirthe 2005-04-22, 7:23 am |
| 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!
>
| |
| Dave Wickert [MSFT] 2005-04-22, 11:23 am |
| 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" < AlexanderHirthe@disc
ussions.microsoft.com> wrote in
message news:FF27CF53-C725-4671-9A60- 7F19434F3030@microso
ft.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[color=darkred]
> the same username and passwort like my domain account.
>
> Alex
>
>
> "AKing" wrote:
>
what to[color=darkred]
| |
| AKing 2005-04-23, 11:23 am |
| @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" < AlexanderHirthe@disc
ussions.microsoft.com> wrote in
> message news:FF27CF53-C725-4671-9A60- 7F19434F3030@microso
ft.com...
> with
> what to
>
>
>
|
|
|
|
|