Hi,
I need help with a problem: When trying to process a analysis services project, I receive the following error message -
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.; 28000; Cannot open database "DocumentDB" requested by the login. The login failed.; 42000.
I am using the service account for impersonation for the datasource. One suggestion I received from the data-access forum was to grant privileges to the local service for the database. I am not clear about the procedure to do that. Can someone please guide me through this I am posting this question in this forum since this is a authentication/privilege issue.
- Sanchet
OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'
imyousuf
Connect to SQL Server and issue the following commands:
use DocumentDB
create user [nt authority\local service]
If you're using SQL Server 2000, you should execute:
use DocumentDB
sp_grantdbaccess [nt authority\local service]
Thanks
Laurentiu
CGS