SSAS 发布报错处理方法 Login failed for user 'NT Service\MSSQLServerOLAPService' 28000

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]

posted @ 2015-02-11 09:51  Haseo  阅读(887)  评论(0编辑  收藏  举报