December 15, 2010 at 6:35 am
Hello All,
I am fairly new to the Analysis Services in SQL Server.
I recently used the SSAS wizard to migrate my SSAS databases from an earlier running SSAS on 2000 version to a server on 2005 version. When I check that the databases everything seems to appear to be migrated fine but when I try to process the cube it provided many errors.
They are not permission errors for sure and I would be able to provide the exact error in my next reply as the server is on production. But does any one have any ideas if I need to configure any properties like ODBC drivers or any compatibility softwares to make these cubes usable.
Please help me out.Thanks in advance if anyone can provide any inputs, ill paste the error shortly.
December 16, 2010 at 1:07 am
Hello Again,
I might sound a bit stupid in changing what I problem faced but I am now able to process the cubes but the different applications that need to process this cube are not.
My Tech lead tells me that we need to configure the ODBC drivers into our new server because of which this is failing.
I am attaching an image that shows the ODBC Data Source Administrator-> Drivers window for my new server on the left and the old on the right. I basically need both to have the same drivers and really need help on this as I am a first timer at this.
If any one has any clue on this please give me some direction as I am looking for anyone to direct me where to look for these details from.
Thanks in advance to any one who can help me out.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply