March 23, 2006 at 8:15 am
i have an interesting issue. would like to find out if someone else had a similar problem. i get the following error when processing a dimension
Initiating transaction in Database 'CACI Cubes'
Processing Dimension 'BAL Periods' failed. No changes have been made to the database.
Start time: 9:42:42 AM
Initializing Dimension 'BAL Periods'
Data source provider error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.;42000; Time:3/23/2006 9:42:42 AM
Data source provider error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.;42000; Time:3/23/2006 9:42:42 AM
Rolling back transaction in Database 'CACI Cubes'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.;42000; Time:3/23/2006 9:42:42 AM
User is able to login to the db via enterprise manager and is a dbo. also the data source connection test succeeds.
I read somewhere on msdn that it might have to do with different versions of MDAC. I have the same dimension running on a different machine without any issues and the MDAC version is MDAC 2.8 RTM whereas MDAC version on the cluster I am getting the error above is MDAC 2.8 SP1. I wonder whats the difference between these two? and could this be the culprit?
does anyone have any idea what might be going on here?
also here is the msdn thread about MDAC
-- start of msdn thread
Check for differences in MDAC versions on the PCs. There was
an issue with earlier MDAC versions where ODBC connections
would ignore the authentication mode and just use windows
authentication no matter what you selected. You can use the
component check to check mdac installations. It's available
at:
http://msdn.microsoft.com/data/mdac/downloads/default.aspx
-- End of MSDN Thread
November 14, 2006 at 9:14 am
Is OLAP service running with LocalSystem account?
November 22, 2006 at 1:26 am
Account what you are using for OLAP service running must have access to the OLTP database. I am using domain system account for running OLAP (not localsystem) and the same account have access to the OLTP database
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply