 | |
OLAP Client connectivity
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
OLAP Client connectivity -
08-20-2004
, 07:03 AM
#2
| |||
| |||
|
|
I'm unable to connect through the OLAP client to the Server. The OLAP server is SQL Server 2000 in Windows 2003. The domain network is Windows 2000 and the Windows 2003 server is not a part of the domain. The client is Windows XP Professional with the client OLAP + service pack 3 installed on it(Logging onto the Windows 2000 domain at boot up). The OLAP client is run on the client computer and an attempt is made to register the OLAP Server by entering the DNS name of the OLAP server, however the OLAP server is not recognized and an 'authentication' error occurs. What is required for the client to connect to the OLAP Server? |
#3
| |||
| |||
|
|
Also, the client user was added to the OLAP administrator group and service pack 3 was installed on the client computer. "Jim" wrote: I'm unable to connect through the OLAP client to the Server. The OLAP server is SQL Server 2000 in Windows 2003. The domain network is Windows 2000 and the Windows 2003 server is not a part of the domain. The client is Windows XP Professional with the client OLAP + service pack 3 installed on it(Logging onto the Windows 2000 domain at boot up). The OLAP client is run on the client computer and an attempt is made to register the OLAP Server by entering the DNS name of the OLAP server, however the OLAP server is not recognized and an 'authentication' error occurs. What is required for the client to connect to the OLAP Server? |
#4
| |||
| |||
|
|
The exact error I'm getting is: "Errors occured whilte connecting to server. Cannot open connection to Analysis server 'mindset'. Error in data [possible data corruption] Do you still want to register this server?" "Jim" wrote: Also, the client user was added to the OLAP administrator group and service pack 3 was installed on the client computer. "Jim" wrote: I'm unable to connect through the OLAP client to the Server. The OLAP server is SQL Server 2000 in Windows 2003. The domain network is Windows 2000 and the Windows 2003 server is not a part of the domain. The client is Windows XP Professional with the client OLAP + service pack 3 installed on it(Logging onto the Windows 2000 domain at boot up). The OLAP client is run on the client computer and an attempt is made to register the OLAP Server by entering the DNS name of the OLAP server, however the OLAP server is not recognized and an 'authentication' error occurs. What is required for the client to connect to the OLAP Server? |
#5
| |||
| |||
|
|
Didn't you say in the first posting that the server wasn't in the domain? You must have a common trusted domain between the client and the server. This is true for both querying and administration. Are you trying to administer this server (using Analysis Manager) or are you going to be just querying this server? -- Dave Wickert [MSFT] dwickert (AT) online (DOT) 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. "Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote in message news:B72D4669-7C4F-479F-BAD4-FF89E16F83C8 (AT) microsoft (DOT) com... The exact error I'm getting is: "Errors occured whilte connecting to server. Cannot open connection to Analysis server 'mindset'. Error in data [possible data corruption] Do you still want to register this server?" "Jim" wrote: Also, the client user was added to the OLAP administrator group and service pack 3 was installed on the client computer. "Jim" wrote: I'm unable to connect through the OLAP client to the Server. The OLAP server is SQL Server 2000 in Windows 2003. The domain network is Windows 2000 and the Windows 2003 server is not a part of the domain. The client is Windows XP Professional with the client OLAP + service pack 3 installed on it(Logging onto the Windows 2000 domain at boot up). The OLAP client is run on the client computer and an attempt is made to register the OLAP Server by entering the DNS name of the OLAP server, however the OLAP server is not recognized and an 'authentication' error occurs. What is required for the client to connect to the OLAP Server? |
#6
| |||
| |||
|
|
I'm going to be both administering and querying the server and your right, and the server is not in the domain. It sounds like the server needs to be added to the domain. I'll give this a shot. "Dave Wickert [MSFT]" wrote: Didn't you say in the first posting that the server wasn't in the domain? You must have a common trusted domain between the client and the server. This is true for both querying and administration. Are you trying to administer this server (using Analysis Manager) or are you going to be just querying this server? -- Dave Wickert [MSFT] dwickert (AT) online (DOT) 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. "Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote in message news:B72D4669-7C4F-479F-BAD4-FF89E16F83C8 (AT) microsoft (DOT) com... The exact error I'm getting is: "Errors occured whilte connecting to server. Cannot open connection to Analysis server 'mindset'. Error in data [possible data corruption] Do you still want to register this server?" "Jim" wrote: Also, the client user was added to the OLAP administrator group and service pack 3 was installed on the client computer. "Jim" wrote: I'm unable to connect through the OLAP client to the Server. The OLAP server is SQL Server 2000 in Windows 2003. The domain network is Windows 2000 and the Windows 2003 server is not a part of the domain. The client is Windows XP Professional with the client OLAP + service pack 3 installed on it(Logging onto the Windows 2000 domain at boot up). The OLAP client is run on the client computer and an attempt is made to register the OLAP Server by entering the DNS name of the OLAP server, however the OLAP server is not recognized and an 'authentication' error occurs. What is required for the client to connect to the OLAP Server? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.