Getting error while creating Data Source View in SSAS 2008 RRS feed

  • Question

  • All,

    Getting below error while creating data source view from wizard in SSAS 2008, at the time of clicking "Finish" button. However, created data source successfully.


    TITLE: Microsoft Visual Studio



    The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)










    Wednesday, November 17, 2010 9:44 PM


All replies

  • What is the SQL Server version your are using. Integration with SQL Compact is not yet available (check the readme)
    Wednesday, November 17, 2010 11:31 PM
  • I am using 2008 version of SQL as mentioned in the title itself. version no-  9.0.30729.1 SP (and .net framework 3.5 SP1)

    I don't think its compatibility issue because using reporting services 2008 am able to do all tasks i.e. authoring, managing, deploying reports etc.

    Any idea for above error?



    Wednesday, November 17, 2010 11:47 PM
  • Are you having a side by side installation of 2005 and 2008. If so, check this article : http://support.microsoft.com/kb/2216460/


    Thursday, November 18, 2010 2:22 AM
  • Has anyone else idea about it?

    Vinu, I am not installing SQL on my machine. If you look at my original post, I am getting this error while dealing with Data Source View wizard within SSAS.



    Thursday, November 18, 2010 4:09 AM
  • I have read your mail properly and I am trying to figure out some minor details that may have affected the installation. Well i have not faced this issue personally and am tying to help you out in figuring out the issue

    1) The post mentions ssas 2008, but underneath the ssas as there is sql, sometime the version of sql might matter. There is no mention about the version of sql in the post.  hence the question

    2) I am aware that you are getting error in data source view. Some articles suggested that side by side installation of SQL 2005 and sql 2008 in the same box can cause this issue or the config file for some reason might have the wrong reference of the assembly. Hence the question. Well also there could be issue with the OLAP provider. you can also check whether you have installed the providers required by ssas to connect to db is installed properly.

    This is not an ideal case. A proper installation should not give you this error. 

    May be someone who has faced the issue can give a faster resolution

    Thursday, November 18, 2010 1:41 PM
  • Hi Vinu,

    I actually have got the install "developer edition" from Microsoft's dreamspark site for sql 2008. So you think it should be the issue as this edition might lack some of features/tools to run the SSAS solution. Because, reporting services is running fine with this install without any issue.


    Thursday, November 18, 2010 6:28 PM
  • Did you install service pack on 2008? It usually fix this problem.


    Ben Mansouri

    Business Intelligence Architect
    Thursday, November 18, 2010 8:24 PM
  • Hi Ben,

    Thanks for replying. I have not installed any service pack seperately as such. Can you pls tell me which serivce pack i should install for SQL 2008 to get rid of this error. Also, can i download it from microsoft 's site. Let me know.



    Thursday, November 18, 2010 9:24 PM
  • Any insights? I anyhow want to get rid of this error to resume cube development on SSAS.


    Friday, November 19, 2010 4:42 PM
  • Try SP1. You can dopwnload it form http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

    Let me know if it fix the issue.

    Ben Mansouri

    Business Intelligence Architect
    • Proposed as answer by Ben Mansouri Monday, November 22, 2010 6:48 PM
    • Marked as answer by Raymond-Lee Friday, November 26, 2010 6:46 AM
    Friday, November 19, 2010 7:27 PM
  • Well that is what is already mentioned in my previous post http://support.microsoft.com/kb/2216460/ tooo...Anyways let us know
    Friday, November 19, 2010 7:46 PM
  • Guys,

    Getting this below error while trying to run SQL Server 2008 SP1 (for my 64 bit machine):- (also, download link given above by Ben, for SP1 i download x64 but it says that file is corrupt; so i had to run another install that i already had, which is this - SQLServer2008SP1-KB968369-x64-ENU ; and it threw below error. ) 


    TITLE: SQL Server Setup failure.



    SQL Server Setup has encountered the following error:


    Invoke or BeginInvoke cannot be called on a control until the window handle has been created..







    Saturday, November 20, 2010 5:49 AM
  • Hi, was able to get rid of SP error installed it successfully and now the original error also has resolved. Thanks,


    Saturday, November 20, 2010 8:22 AM