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

sql-server sql-server-2012 odbc ssas oledb
Merin Nakarmi picture Merin Nakarmi · Sep 9, 2013 · Viewed 18.4k times · Source

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

Answer

Merin Nakarmi picture Merin Nakarmi · Sep 9, 2013

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

:)

Related questions

Is there an overview of all SQL Server 2012 error codes?

SQLGetDiagRec returns a native error code. Is there anywhere an overview of the error codes of SQL Server 2012? I couldn't find anything on MSDN.

Read More
How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More
Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I've had a look through the forum but can't see how. I've looked the the properties but can't see an option, I have seen an answer …

Read More