SQL Server 2012:用户“NT Service\MSSQLServerOLAPService"登录失败.；28000 [英] SQL Server 2012: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000
问题描述
我在 Windows 7 上的 Microsoft SQL Server 2012 中使用分析服务.
I am using Analysis services in Microsoft SQL Server 2012 on Windows 7.
我尝试创建挖掘模型并对其进行处理.处理时出现以下错误.
I tried to create Mining models and process it. I am getting the following error while processing it.
OLE DB 错误:OLE DB 或 ODBC 错误:
用户NT Service\MSSQLServerOLAPService"登录失败.28000.
如何纠正这个问题并成功处理模型?
How to correct this and process the model successfully?
推荐答案
我最近遇到了类似的错误.
I recently encountered a similar error.
我的错误是通过在 ssms 中创建一个新的登录名来修复的，名称是错误给我的.
My error was fixed by creating a new login in ssms, with the name the error gave me.
在您的情况下，它将是 'NT Service\MSSQLServerOLAPService'
In your case it would be 'NT Service\MSSQLServerOLAPService'
然后，您需要在用户映射"页面上新登录的属性中检查db_datareader"和db_datawriter".检查顶部使用的数据库，然后检查底部的db_datareader"和db_datawriter"，其中显示Database Role Membership For: Database_Name.
You then need to check 'db_datareader' and the 'db_datawriter' in that new login's properties on the 'User Mappings' page. Check the database you are using on top and then the 'db_datareader' and 'db_datawriter'on the bottom where it sais 'Database Role Membership For: Database_Name.
希望这会有所帮助.
您还可以尝试的是:转到服务器管理器"、配置"、服务"搜索您使用的SQL Server Analysis Services (Instance_Name)".转到其属性，然后转到登录"选项卡.如果它使用此帐户"选项，请确保使用模拟信息"中多维数据集数据源中指定的帐户作为用户名和密码.
Something you can also try is: Go to the 'Server Manager','Configuration','Services' Search for the 'SQL Server Analysis Services (Instance_Name)' that you use. Go to its Properties and then the 'Log on' tab. If it uses the option of 'This Account', make sure you use that account specified in the data source of the cube in the 'Impersonation Information' as the user name and password.
出现这种情况的原因通常是因为运行该服务的帐户没有执行请求的正确权限.
The reason for this usually is because the account running the service does not have the right permissions to do what is requested.
到目前为止，我知道有两种方法可以做到这一点:
There are 2 ways to do this so far I know:
- 将运行服务的帐户更改为具有正确权限的帐户.
- 为运行该服务的帐户授予正确的权限.
这篇关于SQL Server 2012:用户“NT Service\MSSQLServerOLAPService"登录失败.；28000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
