0

Error 10 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.

I have done settings like congfigation manager>sql server>logon>advanced>addeduser>restarted

but it's saying it again . Can someone help me?

nandu
  • 1
  • 1
  • 2
  • 2
    Someone else posted the same question and has received a couple unaccepted answers that may be useful for you. http://stackoverflow.com/questions/15238559/sql-server-2012-login-failed-for-user-nt-service-mssqlserverolapservice-280 – Mike Zalansky Nov 24 '15 at 16:11

1 Answers1

0
  1. Open 'SQL Server Management Studio' and login to 'Database Engine'.
  2. Go to Security > Logins click on 'New Login...' and give 'NT Service\MSSQLServerOLAPService'.
  3. Restart servers

Should be able to deploy now.

Gayan Dasanayake
  • 1,933
  • 2
  • 17
  • 22