![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Hi, I have setup of MS AS and Office 2002 (Excel 2002) for browsing cube in my office. In office every body is login with Win user ID and have access authority to CUBE. So all user are able to access cube from Excel in office. My Problem, When users are trying to access CUBE from home using login to office network (users have VPN access and they are using DSL/Cable for login to office Network) they are not able to access any cube even though they are in ADMIN group on Server. What Do I need to do to access cube from out side of office but still login to office network? Can any one help? Thanks -Kris |
#3
| |||
| |||
|
|
Many times it is difficult to debug network configuration issues with Analysis Services because network administrators are not very familar with the technology. Thus I typically re-phrase the question. Temporarily create a file share on the Analysis server only allowing read access to the domain>\Users group. This will force the same kind of authentication processes that Analysis Services uses. If you are able to have your users connect and read data from the file share; then they should be able to connect and access Analysis Services. You are just re-defining the security environment into one that they can deal with better. -- 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. "Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote in message news:471F3CEF-EBF0-48C1-A57F-CF592E0F0468 (AT) microsoft (DOT) com... Hi, I have setup of MS AS and Office 2002 (Excel 2002) for browsing cube in my office. In office every body is login with Win user ID and have access authority to CUBE. So all user are able to access cube from Excel in office. My Problem, When users are trying to access CUBE from home using login to office network (users have VPN access and they are using DSL/Cable for login to office Network) they are not able to access any cube even though they are in ADMIN group on Server. What Do I need to do to access cube from out side of office but still login to office network? Can any one help? Thanks -Kris |
#4
| |||
| |||
|
|
Dave, Thanks for yuor reply. However still I am havinh trouble. How can I create a file Share on Analysis Server ? I am not following yuor answer .. Thanks -Kris "Dave Wickert [MSFT]" wrote: Many times it is difficult to debug network configuration issues with Analysis Services because network administrators are not very familar with the technology. Thus I typically re-phrase the question. Temporarily create a file share on the Analysis server only allowing read access to the domain>\Users group. This will force the same kind of authentication processes that Analysis Services uses. If you are able to have your users connect and read data from the file share; then they should be able to connect and access Analysis Services. You are just re-defining the security environment into one that they can deal with better. -- 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. "Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote in message news:471F3CEF-EBF0-48C1-A57F-CF592E0F0468 (AT) microsoft (DOT) com... Hi, I have setup of MS AS and Office 2002 (Excel 2002) for browsing cube in my office. In office every body is login with Win user ID and have access authority to CUBE. So all user are able to access cube from Excel in office. My Problem, When users are trying to access CUBE from home using login to office network (users have VPN access and they are using DSL/Cable for login to office Network) they are not able to access any cube even though they are in ADMIN group on Server. What Do I need to do to access cube from out side of office but still login to office network? Can any one help? Thanks -Kris |
![]() |
| Thread Tools | |
| Display Modes | |
| |