Error: Errors in the metadata manager. LOG file extension can be only .LOG
Symptoms
When attempting to change the collation of Analysis Services, or when attempting to deploy user rights within the Jet Data Manger, the following error message is displayed.
" Errors in the metadata manager. LOG file extension can be only .LOG. Errors in the metadata manager. An error occurred while setting the value of the 'ConfiguratonSettings\Log\File' configuration property. (Microsoft.AnalysisServices)"
Cause
The name of the msmdsrv log file is case sensitive and needs to be corrected.
Resolution
This error can be corrected by editing the msmdsrv.ini file.
-
Navigate to the file path containing the msmdsrv.ini file. The default file path is "C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config\msmdsrv.ini"
Note: The file path above may be different in your environment
-
Right click the file and open with Notepad (you may need to run Notepad as administrator).
-
Find the <File>msmdsrv.log </File> element and change .log to .LOG.
Save the file and close.
-
Navigate to services from the start menu and right click SQL Server Analysis Services (MSSQLServer). Click Restart.