I'm trying to import a table from my SQL server, with analysis services tabular project. Both SQL server and SSAS is installed on my local machine.
I get the option to see the database' table, as the picture below shows.
Display Options for connection with SQL server
But during processing it with the four windows options gives:
impersonate service account throws the error:
*Failed to save modifications to the server. Error returned:
'OLE DB or ODBC error: The credentials provided
for the SQL source are invalid. (Source at desktop-ghgoehf;MyFuckingSQLDB.).
'.*
Impersonate Identity throws the error
Failed to save modifications to the server. Error returned:
'OLE DB or ODBC error: We're sorry, an error occurred during evaluation..
'.
Impersonate Account, I can't even use. I got a windows user tho. But I'm getting the message We couldn't authenticate with the credentials provided. Please try again
Impersonate Unattended Account throws the error
Failed to save modifications to the server. Error returned:
'OLE DB or ODBC error: The credentials provided for
the SQL source are invalid. (Source at desktop-ghgoehf;MyFuckingSQLDB.).
'.
I have tried creating a user for the database, and given it all the permissions possible. But it cannot authenticate it when connecting with 'database'.
I have spend an entire day going through topics on the same issue, but I cannot find anything that has helped me. Some says it may per a permissions issue, but I am not sure how I'd start to debug that.
My database has the containment type set to Partial, which was something I read might help. But it did not for me.
If any information is missing that can help resolve this issue, please ask and I will provide it. Thanks for your help!
You should use "impersonate account" in this scenario.
For account name you need to use format: "Domain name\User account name". As I understand you are not joined to a domain, so type name of your computer instead of domain name, like "MyPc\MyUser" and then provide Windows password.