|
Home > Archive > MS SQL Server OLAP > September 2005 > Manage roles crashes the server
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 |
Manage roles crashes the server
|
|
| Shirish Nair 2005-09-20, 9:23 am |
| Hi All,
Click on the manage roles eneter the details, when you click on submit it
gives error as Database or object read only and aborts.
Worst the entire the analysis service goes for a toss and becomes unusable.
The only way I found to make it up was to reinstall the analysis server and
restore the database.
One important fact here is that I am loggin to the server using my domain id
which is configured as administrator, OLAPAdministrator. Also I am
working/installing through remote desktop connection.
The same things work fine on my local Analysis server.
Any ideas as to why this could happen and what is the solution
Thank you
Shirish
| |
| Darren Gosbell 2005-09-21, 7:23 am |
| I have not had this exact issue, but I have had strange issues at one
client where AD group policy was revoking some permissions. It would
only kick-in after half an hour or so - group policy would come in and
revoke permissions that the install package had configured.
After you have installed, get your network admin people to check that
the OLAP Administrators local group on the AS box have permission to the
hidden MsOLAPRepository$ share (which usually points to "c:\program
files\microsoft analysis services\bin" in the default install)
You can test this by trying to access \\<server>\MsOlapRepository$ from
you workstation. If you are in the OLAPAdminsitrators group and the
permissions are correct you should be able to see a list of files AND
you should be able to create and delete files. (I usually right-click
and create an empty text file and then delete it)
--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <B11E9A09-887F-4DF8-A8E9- 55BC0B104CC3@microso
ft.com>,
ShirishNair@discussi
ons.microsoft.com says...
> Hi All,
>
> Click on the manage roles eneter the details, when you click on submit it
> gives error as Database or object read only and aborts.
> Worst the entire the analysis service goes for a toss and becomes unusable.
> The only way I found to make it up was to reinstall the analysis server and
> restore the database.
> One important fact here is that I am loggin to the server using my domain id
> which is configured as administrator, OLAPAdministrator. Also I am
> working/installing through remote desktop connection.
>
> The same things work fine on my local Analysis server.
>
> Any ideas as to why this could happen and what is the solution
>
> Thank you
>
> Shirish
>
|
|
|
|
|