MS SQL Server OLAP - msmdarch does not work!!!

Author

msmdarch does not work!!!

Watson Xavier

2005-09-21, 3:24 am

Hi,

No matter how much I tried, I can't get msmdarch archive a database from a
command line...

Doesn't give any errors...doesn't display anything at all...

OS: Windows 2000 with SQL 2000 and AS and sp3

SQLAgent running on local administrator's account (in the OLAP
Administrators group as well).

Please help me....

What could be wrong?

Watson

Tiago Rente

2005-09-21, 7:23 am

Hi,

Sometimes that happens!
I have seen it in at least 2 situations:
* Only 1 instance of msmdarch can be executing on the server. Maybe other
user is alreading using it.
* You are having privilege problems in some of the directories. E.g., no
access to the OLAPDATA, or to the “Program Files” (it maybe odd but sometimes
I need to have write privileges on the “Program Files” directory or at least
on “C:\Program Files\Microsoft Analysis Services”), or to the temp and
destination directory/file.

"Watson Xavier" wrote:

> Hi,
>
> No matter how much I tried, I can't get msmdarch archive a database from a
> command line...
>
>
> Doesn't give any errors...doesn't display anything at all...
>
> OS: Windows 2000 with SQL 2000 and AS and sp3
>
> SQLAgent running on local administrator's account (in the OLAP
> Administrators group as well).
>
>
> Please help me....
>
>
> What could be wrong?
>
>
> Watson
>

Watson Xavier

2005-09-21, 7:23 am

Hi,

Thanks so much for the reply...but the AS is only on my pc and i logged in
as the Administrator...

In Windows 2003 though, there is problem where the folders are demarked as
ReadOnly even though they are not...

But I tested this on a Windows 2000 Pofessional and logged on as the local
Adminstrator....still no luck...

what else could be wrong...

On Wed, 21 Sep 2005 14:35:04 +0600, Tiago Rente""
< TiagoRente@discussio
ns.microsoft.com> wrote:
[color=darkred]
> Hi,
>
> Sometimes that happens!
> I have seen it in at least 2 situations:
> * Only 1 instance of msmdarch can be executing on the server. Maybe
> other
> user is alreading using it.
> * You are having privilege problems in some of the directories. E.g.,
> no
> access to the OLAPDATA, or to the “Program Files” (it maybe odd but
> sometimes
> I need to have write privileges on the “Program Files” directory or at
> least
> on “C:\Program Files\Microsoft Analysis Services”), or to the temp and
> destination directory/file.
>
> "Watson Xavier" wrote:
>

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Tiago Rente

2005-09-21, 7:23 am

Hi,

We were also Administrators and also had privilege problems! E.g., if you
UNC make sure that you have full control on both the share and physical disk.

We were able to put it work giving Full Control from "C:\Program Files" as
ALL its sub-directories. It might be a security breach but it works.

"Watson Xavier" wrote:

> Hi,
>
> Thanks so much for the reply...but the AS is only on my pc and i logged in
> as the Administrator...
>
> In Windows 2003 though, there is problem where the folders are demarked as
> ReadOnly even though they are not...
>
> But I tested this on a Windows 2000 Pofessional and logged on as the local
> Adminstrator....still no luck...
>
> what else could be wrong...
>
> On Wed, 21 Sep 2005 14:35:04 +0600, Tiago Rente""
> < TiagoRente@discussio
ns.microsoft.com> wrote:
>
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>

Darren Gosbell

2005-09-21, 7:23 am

Can you run an Archive from Analysis Manager? (you may get better error=20
messages from the GUI)

Try accessing the \\<server>\MsOlapRepository$ share and see if you can=20
create a simple text file and delete it, if not there is something wrong=20
with your permissions.

The MsOlapRepository$ share is a hidden share used for accessing the=20
access repository. Some of these issues go away when you use SQL Server=20
for the repository.

--=20
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <E2356DA9-A71F-4532-8FC8- F6728AC9C564@microso
ft.com>,=20
TiagoRente@discussio
ns.microsoft.com says...
> Hi,
>=20
> We were also Administrators and also had privilege problems! E.g., if you=
=20
> UNC make sure that you have full control on both the share and physical d=
isk.
>=20
> We were able to put it work giving Full Control from "C:\Program Files" a=
s=20[color=darkred]
> ALL its sub-directories. It might be a security breach but it works.
>=20
> "Watson Xavier" wrote:
>=20
in =20[color=darkred]
as =20[color=darkred]
cal =20[color=darkred]
=20[color=darkred]
.., =20[color=darkred]
maybe odd but =20[color=darkred]
=9D directory or at =20[color=darkred]
r to the temp and[color=darkred]
=20[color=darkred]

Paul

2005-09-23, 9:23 am

Hi,

What is the exact string you are passing?

Ta
Paul

"Watson Xavier" wrote:

> Hi,
>
> No matter how much I tried, I can't get msmdarch archive a database from a
> command line...
>
>
> Doesn't give any errors...doesn't display anything at all...
>
> OS: Windows 2000 with SQL 2000 and AS and sp3
>
> SQLAgent running on local administrator's account (in the OLAP
> Administrators group as well).
>
>
> Please help me....
>
>
> What could be wrong?
>
>
> Watson
>

Sponsored Links