Migrating AS 2000 Database to 2005

Last Post 04 Jan 2008 10:39 AM by kjmcsd. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kjmcsd
New Member
New Member

--
04 Jan 2008 10:14 AM
I just finish going through the migration wizard and successfully migrated an AS 2000 database to 2005. But now I cannot browse the data of my cubes until I deploy and process everything.

How do I do that? I see where it allows me to process the database but I'm getting errors and I think its because I did not deploy it first. Please Help.

Thanks!
SQLUSA
New Member
New Member

--
04 Jan 2008 10:35 AM
What kind of errors?

Where are you? In BIDS or in Management Studio?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005highperformance/ The Best SQL Server 2005 Training in the World!
kjmcsd
New Member
New Member

--
04 Jan 2008 10:39 AM
These are the errors. The first one I have no clue why I'm getting. The others I cannot understand




Errors and Warnings from Response
OLE DB error: OLE DB or ODBC error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'ABCMart', Name of 'ABCMart'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'ABC OLAP DEV', Name of 'Trans Date' was being processed.
SQLUSA
New Member
New Member

--
04 Jan 2008 11:57 AM
Open it up in BIDS designer.

Double click on data source(s)

Edit connection string ( setup login)
You are not authorized to post a reply.

Acceptable Use Policy