Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
shahab03
Starting Member
28 Posts |
Posted - 2006-03-23 : 10:51:11
|
When I process the dimension I get following errorInitiating transaction in Database 'CACI Cubes'Processing Dimension 'BAL Periods' failed. No changes have been made to the database.Start time: 9:42:42 AMInitializing 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 AMData 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 AMRolling 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 AMUser is able to login to the db via enterprise manager and is a dbo. also the data source connection test succeeds. I am not sure what could be causing this error? any idea?domain is also the same. |
|
|
|
|