Users unable to login to Analysis Server Database

#1

I have a VB application that queries data from an analysis
services cubes. When users try to login to the anaylsis
server they get a 'Database not found' error. However if I
give the users administrative rights to the server then
they can login without any problem. The application also
uses DSO objects.

Is there any other way besides giving admin rights to the
users.

Thanks in advance for your help.

#2

Khalid,
You remembered to use Analysis Manager and map the user accounts to a
Database Role, right? If not, only admins can connect.

Jon Jahren

"Khalid Ahmed" <kahlid_ahmed (AT) hotmail (DOT) com> wrote

Quote:

I have a VB application that queries data from an analysis
services cubes. When users try to login to the anaylsis
server they get a 'Database not found' error. However if I
give the users administrative rights to the server then
they can login without any problem. The application also
uses DSO objects.

Is there any other way besides giving admin rights to the
users.

Thanks in advance for your help.

#3

Hello,

The repository is a mdb file in the Bin folder oof analysis services and
the folder is share under MsOLAPRepository$. The user you use can't access
the file. The user must have the right to the directory, you can try to
connect at \\ServerName\MsOLAPRepository$

Hope this Help

Patrice

"Khalid Ahmed" <kahlid_ahmed (AT) hotmail (DOT) com> wrote

Quote:

I added the users to the olap Administrators group. But I
am still getting the following error when I try to connect
using DSO.
Cannot connect to the Repository

-----Original Message-----
Oops, I misread you questions. If you access AS with DSO
you need to be an
OLAP admin. Remember they don't need to have local admin
rights so in most
cases this is an acceptable security practice.

Jon Jahren

"Jon Jahren" <nospam_jon (AT) softscenario (DOT) no> wrote in message
news:OM4vzMaXDHA.656 (AT) tk2msftngp13 (DOT) phx.gbl...
Khalid,
You remembered to use Analysis Manager and map the user
accounts to a
Database Role, right? If not, only admins can connect.

Jon Jahren

"Khalid Ahmed" <kahlid_ahmed (AT) hotmail (DOT) com> wrote in
message
news:0c6301c35cf5$b9534190$a501280a (AT) phx (DOT) gbl...
I have a VB application that queries data from an
analysis
services cubes. When users try to login to the
anaylsis
server they get a 'Database not found' error. However
if I
give the users administrative rights to the server
then
they can login without any problem. The application
also
uses DSO objects.

Is there any other way besides giving admin rights to
the
users.

Thanks in advance for your help.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Users unable to login to Analysis Server Database

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Users unable to login to Analysis Server Database - 08-07-2003 , 11:08 AM

Re: Users unable to login to Analysis Server Database - 08-08-2003 , 07:49 AM

Re: Users unable to login to Analysis Server Database - 08-08-2003 , 03:42 PM