September 22, 2012 at 11:37 am
I am using SQL Server 2012 developer edition on Windows 7. I have the following error attempting to process a dimension: OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService' 28000
I am new to SSAS and I have researched this thoroughly but still having trouble and don't have a lot of knowledge of all the different types of accounts.
Thank you very much!
September 22, 2012 at 1:09 pm
September 22, 2012 at 1:34 pm
Thank you for your help. No, I'm not trying to access the cube remotely. This is a brand new SQL Server 2012 developer edition install with the default accounts on a laptop. The error occurred when I tried to process a dimension I created. I've done a lot of Google searches trying to get an answer and this article on the link below seemed to be the most relevant information:
http://support.microsoft.com/kb/224973
By changing the MSSQLServerOLAPService service to run under a domain or local user account that is a member of the OLAP Administrators group on the OLAP server and that has privileges on SQL Server, OLAP Services will be able to successfully process.
My settings are: In my SQL Server Configuration Manager>SQL Server Analysis Services>Properties>Log On As>This account: NT Service\MSSQLServerOLAPService [with a default password supplied during the install]
I don't know if the accounts are correct or how to find the OLAP Administrators group on the OLAP server in a Windows 7 environment. I am very new to SSAS.
Thank you!
September 22, 2012 at 2:11 pm
SOLUTION FOUND
I found the answer here on the MS SQL Server Forum for Analysis Services:
Solution for: OLE DB or ODBC error:Login failed for user NT Service\MSSQLServerOLAPService error - create new login in the SQL Server database engine so analysis services can read the data in the database being analyzed.
Create login and grant access:
Open up SQL Server Management Studio [login to the database engine]>
Security >
Login (Right? click) >
New Login >add user: "NT Service\MSSQLServerOLAPService">
select the database being analyzed in the drop-down list at the bottom >
User Mapping [click on the database in the list] >
In the window database role membership click on db_datareader [this grants access to read the data]
More details here http://msdn.microsoft.com/en-us/library/ms189751.aspx
Hope this helps!
Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com
http://shahfaisalmuhammed.blogspot.com/2012/09/login-failed-for-mssqlserverolapservice.html
Thank you everyone who helped me - thank you very much!
January 18, 2013 at 10:36 am
Thanks for the info, I was having trouble with this as well.
March 12, 2013 at 2:33 pm
Oh my gosh I'm so glad you posted this. I've been struggling for hours and this was exactly the thing that fixed it. Thanks
April 3, 2013 at 3:52 am
I have found another solution to the problem. Please see:
http://sqlserverandme.blogspot.com/2013/04/a-solution-for-ssas-deployment-error.html
April 3, 2013 at 10:43 pm
You can also find the Windows Service (services.msc) and change the login account to one that already has access to your DB.
April 25, 2013 at 6:07 am
Thanks, adding read right to SQLServerMSASUser$computer_name$instance_name solved the problem!
May 30, 2013 at 3:54 pm
Yep, worked for me.
July 10, 2013 at 2:28 pm
Thanks, This solution has worked for me.
August 23, 2013 at 11:44 am
Thanks worked well.
February 3, 2014 at 8:53 am
Your solution worked for me.. Thanks a lot 🙂
March 5, 2014 at 10:53 pm
Almost one year later, the solution provided is still good. I scoured the Internet looking for this solution and was so glad that you good folks have solved it. Thank you.
May 7, 2014 at 3:00 pm
Thank you so much it works me too:-)
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply