sql-serversql-server-2012odbcssasoledb

OLEDE Error: Login failed for user 'DOMAIN\ComputerName$'.;28000

I am trying to deploy an Analysis Services cube in SQL Server 2012. My user account is REALM\Merin where REALM is the domain and my computer's name is Hercules. I am already in Analysis Service's administrator group. When I process the cube using SQL Server Data Tools, I get following error.

OLE DB error: OLE DB or ODBC error. Login failed for user 'REALM\Hercules$'.; 28000.

My user account is REALM\Merin but I don't know why it is complaining about user REALM\Hercules$. What does this account mean? A user with ComputerName + $ is strange to me. Someone help please.

Thanks, Merin

Solution

  • I did not understand about the ComputerName$, but I was able to resolve my Cube deployment error. Below are the steps:

    1. Double click the data source in the Analysis Project Click
    2. Impersonation Information tab
    3. Select Use a specific Windows user name and password
    4. Enter user name and password and click OK
    5. Process the Cube

    :)