Has anyone seen this error before? If so, how did you fix it? I can't find anything on Google.
Here is what I have done:
I tried doing a Google search but practically nothing came up.
I checked all of my permissions everywhere, and from what I can tell, that is not the problem.
Building and deploying does not generate errors.
I only have errors when I try to process my cube.
Edit #1:
I have attached an image showing version information. I have never successfully processed a cube. I have been getting this from the very beginning of when I tried to process one.
Edit #2
Sorry for the delay, but I ran into some errors thanks to Windows latest update.
I am no longer receiving this error message after reinstalling everything, but this is what I have now:
I am trying to teach myself how to use SSAS for self-learning. I downloaded the database somewhere from Microsoft.
I had to uninstall/reinstall Visual Studio as well as SQL Server due to an update that was causing errors.
After doing so, I was no longer able to reproduce the error message in part #1; however, part #2, Login failed for user NT Service \MSSQLServerOLAPService.;28000
, was resolved by doing the following:
Logging into SQL Server Management Studio
Creating a new login for NT Service \MSSQLServerOLAPService
.
Assigning the db_datareader
and db_datawriter
role
memberships.
After following these steps, I did not have any trouble processing my cube.
If I am able regenerate error #1 again, I will add more detail to my post, otherwise, I am problem free for the time being.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With