Where is the SSAS2005 data folder setting in the registry? Can't seem to
find it.

It is not in the registry in AS 2005. It is in a configuration file called
msmdsrv.ini -- you should rather use the Server Configuration Properties
window (available using the server properties in SSMS).

Be careful changing the data folder though if you already have objects
deployed to the current data folder -- the server administrators role and
other metadata objects will not be automatically propogated to the new data
folder.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

My issue is that someone has deleted it, so whenever AS is restarted it
can't restart since it can't find the data folder.





"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote

AS will re-create the data folder if it has been completely deleted --
unless perhaps it doesn't have permissions. The main thing is that the AS
service account should be able to access and modify the data folder --
because given an empty folder, it will automatically initialize it with the
minimum files it needs.

If you just re-create the directory, then it should work. Alternatively, you
can notepad <installdir>\config\msmdsrv.ini and modify the DataDir value to
something you prefer.

Thanks,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

thanks this solution worked.

reason the service wouldnt come back up is because the drive was detached.


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote