SQL Server Administration, Development and B.I. Development related
"Access is denied" on msmdsrv.ini
Today, I try to see the feature settings in msmdsrv.ini file in the OLAP\Config folder. However, I get an "Access is denied" message. The login ID has the admin right. Under the folder, there are msmdsrv.ini and msmdsrv.bak files (do not know when the system created the .bak file and why). The .bak file is newer than the .ini file. Finally, I moved the .ini to somewhere else and renamed the .bak file to .ini file. The problem is solved.