- You have SQL server installed on your local machine with localhost as the only instance
- You have SQL server analysis serviecs installed on the machine
- You used SSAS to build a cube and tried to deploy the cube on localhost and got error OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
To resolve this error, do the following
- Right click on My Computer and click Manage
- On the left hand side, expand Services and Applications and click on Services
- Locate service SQL Server Analysis Service
- Right click on it, and click on Properties
- Go to LogOn tab
- Ensure that radio button Local System Account is checked
- Now restart the service.
Try building the cube again. It should work fine.
The following is the screen shot of the final screen.
