Error creating datasource

A user is getting an error "Cannot update, database or object is read-only"
when creating a datasource.
The user has db_owner role of the database that's being connected to.
I know very little of Analysis Server and any help would be appreciated.
Thanks.
RonThis is the typical error when two or more users are using SQL Analysis
Manager and the Olap repository is still in MS Access database, which it's
oppened in exclusive mode by Analysis Manager.
Try migrating Olap Repository to SQL Server and hopefully your problem is
gone.
Michael Prendergast
"Ron" <Ron@.discussions.microsoft.com> escribi en el mensaje
news:CC03234F-0585-41A7-8128-078EB865B5AA@.microsoft.com...
>A user is getting an error "Cannot update, database or object is read-only"
> when creating a datasource.
> The user has db_owner role of the database that's being connected to.
> I know very little of Analysis Server and any help would be appreciated.
> Thanks.
> Ron
>|||There's no Access involved - just SQL Server
Ron
"MPS" wrote:

> This is the typical error when two or more users are using SQL Analysis
> Manager and the Olap repository is still in MS Access database, which it's
> oppened in exclusive mode by Analysis Manager.
> Try migrating Olap Repository to SQL Server and hopefully your problem is
> gone.
> Michael Prendergast
>
> "Ron" <Ron@.discussions.microsoft.com> escribió en el mensaje
> news:CC03234F-0585-41A7-8128-078EB865B5AA@.microsoft.com...
>
>|||How do you migrate the OLAP Repository (Access) to a SQL Server?
"MPS" wrote:

> This is the typical error when two or more users are using SQL Analysis
> Manager and the Olap repository is still in MS Access database, which it's
> oppened in exclusive mode by Analysis Manager.
> Try migrating Olap Repository to SQL Server and hopefully your problem is
> gone.
> Michael Prendergast
>
> "Ron" <Ron@.discussions.microsoft.com> escribió en el mensaje
> news:CC03234F-0585-41A7-8128-078EB865B5AA@.microsoft.com...
>
>|||Open Analysis Manager, select the server name in the list (typically one),
right click over the server name and there you are, MIGRAR DEPOSITO in
Spanish, MIGRATE REPOSITORY I guess in English (I use Spanish version
You will need a DB created in SQL Server and connect to it with owner
privileges over that database
"Rodrigo" <Rodrigo@.discussions.microsoft.com> escribi en el mensaje
news:515C83DA-0157-4E12-9832-DAD3A18AC8E8@.microsoft.com...
> How do you migrate the OLAP Repository (Access) to a SQL Server?
>
> "MPS" wrote:
>
>|||Just in case, default installation for MS Analysis Services manages Olap
repository in an Access Database.
Probably you do not have any data in Access, but the repository, if is not
migrated yet, It's still in a MS Access Database. The file is named
msmdrep.mdb and has two tables, OlapObjects and Server.
Hope it helps,
Michael Prendergast
"Ron" <Ron@.discussions.microsoft.com> escribi en el mensaje
news:6DB504F8-F1CB-4EFB-A216-8A50909012E5@.microsoft.com...
> There's no Access involved - just SQL Server
> Ron
> "MPS" wrote:
>
>|||That did the trick - Thanks MPS.
"MPS" wrote:

> Just in case, default installation for MS Analysis Services manages Olap
> repository in an Access Database.
> Probably you do not have any data in Access, but the repository, if is not
> migrated yet, It's still in a MS Access Database. The file is named
> msmdrep.mdb and has two tables, OlapObjects and Server.
> Hope it helps,
> Michael Prendergast
> "Ron" <Ron@.discussions.microsoft.com> escribió en el mensaje
> news:6DB504F8-F1CB-4EFB-A216-8A50909012E5@.microsoft.com...
>
>|||Good to hear that
Michael Prendergast
"Ron" <Ron@.discussions.microsoft.com> escribi en el mensaje
news:0727D691-8903-4472-97BC-1A9F65508608@.microsoft.com...
> That did the trick - Thanks MPS.
> "MPS" wrote:
>
>

Error Adding User

Hello, I have a problem with adding users to a database using sp_adduser.
The user I'm using is a member of db_owner but I receive the following error:
sp_adduser adam, adam, DEFAULT_USERS
Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
User does not have permission to perform this action
It only works when I log in as a System Administrator. However if I login as
the db_owner account which generates the above error and run the following:
exec sp_grantdbaccess adam
exec sp_addrolemember DEFAULT_USERS, adam
It works fine. The problem is that it is a piece of 3rd party software that
is trying to add the users and won't be easy to get them to change it as
sp_adduser should work. Also I don't want them logging in as System
Administrator when I could try and fix it. Any ideas?
One solution is to drop the user from the database, and then make its login
the owner of the database:
sp_dropuser 'the_user'
go
use the_database
go
sp_changedbowner 'the_login'
go
Linchi
"Adam Sankey" wrote:

> Hello, I have a problem with adding users to a database using sp_adduser.
> The user I'm using is a member of db_owner but I receive the following error:
> sp_adduser adam, adam, DEFAULT_USERS
> Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> User does not have permission to perform this action
> It only works when I log in as a System Administrator. However if I login as
> the db_owner account which generates the above error and run the following:
> exec sp_grantdbaccess adam
> exec sp_addrolemember DEFAULT_USERS, adam
> It works fine. The problem is that it is a piece of 3rd party software that
> is trying to add the users and won't be easy to get them to change it as
> sp_adduser should work. Also I don't want them logging in as System
> Administrator when I could try and fix it. Any ideas?
>
|||Thanks very much that worked fine - I still don't understand why I had this
problem in the first place. Do you have an insight in to this?
Thanks again
Adam
"Linchi Shea" wrote:
[vbcol=seagreen]
> One solution is to drop the user from the database, and then make its login
> the owner of the database:
> sp_dropuser 'the_user'
> go
> use the_database
> go
> sp_changedbowner 'the_login'
> go
> Linchi
> "Adam Sankey" wrote:

Error Adding User

Hello, I have a problem with adding users to a database using sp_adduser.
The user I'm using is a member of db_owner but I receive the following error:
sp_adduser adam, adam, DEFAULT_USERS
Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
User does not have permission to perform this action
It only works when I log in as a System Administrator. However if I login as
the db_owner account which generates the above error and run the following:
exec sp_grantdbaccess adam
exec sp_addrolemember DEFAULT_USERS, adam
It works fine. The problem is that it is a piece of 3rd party software that
is trying to add the users and won't be easy to get them to change it as
sp_adduser should work. Also I don't want them logging in as System
Administrator when I could try and fix it. Any ideas?One solution is to drop the user from the database, and then make its login
the owner of the database:
sp_dropuser 'the_user'
go
use the_database
go
sp_changedbowner 'the_login'
go
Linchi
"Adam Sankey" wrote:
> Hello, I have a problem with adding users to a database using sp_adduser.
> The user I'm using is a member of db_owner but I receive the following error:
> sp_adduser adam, adam, DEFAULT_USERS
> Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> User does not have permission to perform this action
> It only works when I log in as a System Administrator. However if I login as
> the db_owner account which generates the above error and run the following:
> exec sp_grantdbaccess adam
> exec sp_addrolemember DEFAULT_USERS, adam
> It works fine. The problem is that it is a piece of 3rd party software that
> is trying to add the users and won't be easy to get them to change it as
> sp_adduser should work. Also I don't want them logging in as System
> Administrator when I could try and fix it. Any ideas?
>|||Thanks very much that worked fine - I still don't understand why I had this
problem in the first place. Do you have an insight in to this?
Thanks again
Adam
"Linchi Shea" wrote:
> One solution is to drop the user from the database, and then make its login
> the owner of the database:
> sp_dropuser 'the_user'
> go
> use the_database
> go
> sp_changedbowner 'the_login'
> go
> Linchi
> "Adam Sankey" wrote:
> > Hello, I have a problem with adding users to a database using sp_adduser.
> > The user I'm using is a member of db_owner but I receive the following error:
> >
> > sp_adduser adam, adam, DEFAULT_USERS
> >
> > Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> > User does not have permission to perform this action
> >
> > It only works when I log in as a System Administrator. However if I login as
> > the db_owner account which generates the above error and run the following:
> >
> > exec sp_grantdbaccess adam
> > exec sp_addrolemember DEFAULT_USERS, adam
> >
> > It works fine. The problem is that it is a piece of 3rd party software that
> > is trying to add the users and won't be easy to get them to change it as
> > sp_adduser should work. Also I don't want them logging in as System
> > Administrator when I could try and fix it. Any ideas?
> >

Error Adding User

Hello, I have a problem with adding users to a database using sp_adduser.
The user I'm using is a member of db_owner but I receive the following error
:
sp_adduser adam, adam, DEFAULT_USERS
Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
User does not have permission to perform this action
It only works when I log in as a System Administrator. However if I login as
the db_owner account which generates the above error and run the following:
exec sp_grantdbaccess adam
exec sp_addrolemember DEFAULT_USERS, adam
It works fine. The problem is that it is a piece of 3rd party software that
is trying to add the users and won't be easy to get them to change it as
sp_adduser should work. Also I don't want them logging in as System
Administrator when I could try and fix it. Any ideas?One solution is to drop the user from the database, and then make its login
the owner of the database:
sp_dropuser 'the_user'
go
use the_database
go
sp_changedbowner 'the_login'
go
Linchi
"Adam Sankey" wrote:

> Hello, I have a problem with adding users to a database using sp_adduser.
> The user I'm using is a member of db_owner but I receive the following err
or:
> sp_adduser adam, adam, DEFAULT_USERS
> Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
> User does not have permission to perform this action
> It only works when I log in as a System Administrator. However if I login
as
> the db_owner account which generates the above error and run the following
:
> exec sp_grantdbaccess adam
> exec sp_addrolemember DEFAULT_USERS, adam
> It works fine. The problem is that it is a piece of 3rd party software tha
t
> is trying to add the users and won't be easy to get them to change it as
> sp_adduser should work. Also I don't want them logging in as System
> Administrator when I could try and fix it. Any ideas?
>|||Thanks very much that worked fine - I still don't understand why I had this
problem in the first place. Do you have an insight in to this?
Thanks again
Adam
"Linchi Shea" wrote:
[vbcol=seagreen]
> One solution is to drop the user from the database, and then make its logi
n
> the owner of the database:
> sp_dropuser 'the_user'
> go
> use the_database
> go
> sp_changedbowner 'the_login'
> go
> Linchi
> "Adam Sankey" wrote:
>