October 16, 2007 at 3:47 am
Hi everyone
I have created anyalys project and while running the applicaion.
I amgetting the error :
I checked all the obvious problems. The password is right and the login works perfectly.
Here is the output from Developer Studio when trying to deploy/process a cube:
"The following system error occurred: Logon failure: unknown user name or bad password"
The following system error occurred: Logon failure: unknown user name or bad password
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'LH', Name of 'LH'
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Groups', Name of 'Groups' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Addr2' attribute of the 'Groups' dimension from the 'Analysis Services Project1' database was being processed.
Internal error: The operation terminated unsuccessfully.
My Analysis Services project (or Business Intelligence project) has only one Data Source, "LH.ds". I'm using a SQL Server login with a saved password.
I double click the data source to get to the "Data Source Designer" dialog and see the following connection string:
Provider=SQLNCLI.1;Data Source=servername;Persist Security Info=True;Password=pwd;User ID=userid;Initial Catalog=LH
I click "Edit" and "Test Connection" and get "Test connection succeeded". The "Save my password" option is checked. The password is fine and the login should works perfectly. Developer Studio can obviously connect to the database since I've done all the design through it. I can't imagine why I'm getting this error.
Pleae help me
regards
sthanika
October 20, 2007 at 8:22 pm
sthanika,
When you dbl-click to bring up the properties of the datasource,there's two tabs,the first 'General' contains the connection string etc, the second 'Account Impersonation' is used to specify how the service is to access the datasource (e.g impersonate a windows uers, use a fixed username/password combination etc). Have you set the username and password on that tab? It sounds like it could be trying to access the database using the Service Account which may not have DB access.
HTH,
Steve.
Steve.
February 22, 2008 at 12:24 pm
I had the same issue. As the other post mentioned the DataSource settings pages has two tabs. In the Impersonation Information tab, set the impoersonation to default and it should work fine.
November 6, 2008 at 3:25 pm
Please help... I have the same error:
when I run this query:
EXEC master..xp_cmdshell 'MKDIR \\ServerName\FolderName'
I got this error msg:
Logon failure: unknown user name or bad password.
it works fine if I run it in cmd prompt.
PLease help me... this is my problem for a week now.
Thanks!
June 27, 2011 at 9:06 am
Hi sthanika,
Did you solve the above Issue?
I am running into same issue, I see the Data source and Impersonation Info is right.
But still throwing same error when using to process the Dimension.
Thanks.
May 28, 2017 at 10:54 pm
sthanika - Tuesday, October 16, 2007 3:47 AMHi everyone I have created anyalys project and while running the applicaion.I amgetting the error :I checked all the obvious problems. The password is right and the login works perfectly. Here is the output from Developer Studio when trying to deploy/process a cube:"The following system error occurred: Logon failure: unknown user name or bad password"The following system error occurred: Logon failure: unknown user name or bad passwordErrors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'LH', Name of 'LH'Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Groups', Name of 'Groups' was being processed.Errors in the OLAP storage engine: An error occurred while the 'Addr2' attribute of the 'Groups' dimension from the 'Analysis Services Project1' database was being processed.Internal error: The operation terminated unsuccessfully.My Analysis Services project (or Business Intelligence project) has only one Data Source, "LH.ds". I'm using a SQL Server login with a saved password.I double click the data source to get to the "Data Source Designer" dialog and see the following connection string:Provider=SQLNCLI.1;Data Source=servername;Persist Security Info=True;Password=pwd;User ID=userid;Initial Catalog=LHI click "Edit" and "Test Connection" and get "Test connection succeeded". The "Save my password" option is checked. The password is fine and the login should works perfectly. Developer Studio can obviously connect to the database since I've done all the design through it. I can't imagine why I'm getting this error.Pleae help meregardssthanika
May 28, 2017 at 11:03 pm
Hi,
I have connected to the datasource(database) through the sa account and then impersonation option set to be inherit.
It is working fine . you can follow as below:-
1) Double click on the Datasource and go the General Tab
2) Click on the connection string Edit option
3) Connect the Database through the SQL Server Authentication with SA Account and test the connection
4)click ok
5) Go to the Impersonation Table
6)Select the Inherit Option
Please let me know if you have any question.
May 28, 2017 at 11:06 pm
Please note: 10 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply