Hello all,

I changed the password that I use for my AS 2005 database. I changed
it in the data source, so when I go into the connection there, I can
connect properly (when I click the Edit button for the Connection
String, and then hit Test Connection).

However, when I go to a dimension, and try to process it, I get the
error:

OLE DB error: OLE DB or ODBC error: Login failed for user
'[MyUserName]'.; 42000.

Errors in the high-level relational engine. A connection could not be
made to the data source with the DataSourceID of '[MyDatabaseName]',
Name of '[MyDatabaseName]'.

Where else do I need to change the password?

Thanks,
Sylvia

As the error message says, you need to also change the password for
your relational database. SQL 2005 and AS 2005 are two different
animals.

Chu

Sylvia wrote:

Sorry, I should have said "I changed the password on the SQL Server
login that I use for AS 2005 to connect to my SQL Server database".

Where else do I need to change it?

thanks,
Sylvia


iloveseahawks (AT) gmail (DOT) com wrote:

What did you set in "ImpersonationInfo"? Have you updated that as well
if you are not impersonating service account?

Thanks,
Chu

Sylvia wrote:

I've tried all the ImpersonationInfo options - use specific name and
password, use service account, credentials of the current user, and
default.

When I use the "specific name and password", it never saves the
password information.

Also, in the Connection Manager, under SQL Server Authentication, it
has an option to save password. It also NEVER saves the password in
there. So, when I first input my login, password info, and hit 'test
connection', it succeeds. Then, when I click ok, then shut down the
Data Sources properties, and then reopen it, the password has
disappeared.

thanks,
Sylvia


iloveseahawks (AT) gmail (DOT) com wrote:

Anyone else care to comment? Seems like someone else must have run
into this before.

thanks,
Sylvia



Sylvia wrote: