Getting error while creating Data Source View in SSAS 2008

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)

 

------------------------------

BUTTONS:

 

OK

------------------------------

 

 

 

Answer 1

What is the SQL Server version your are using. Integration with SQL Compact is not yet available (check the readme)

---

vinu

Answer 2

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?

 

-Thanks,

Answer 3

Are you having a side by side installation of 2005 and 2008. If so, check this article : http://support.microsoft.com/kb/2216460/

 

---

vinu

Answer 4

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.

 

Thanks,

Answer 5

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

---

vinu

Answer 6

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.

Thanks, 

Answer 7

Did you install service pack on 2008? It usually fix this problem.

Cheers,

Ben Mansouri

---

Business Intelligence Architect

Answer 8

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.

Thanks,

 

Answer 9

Any insights? I anyhow want to get rid of this error to resume cube development on SSAS.

--T

Answer 10

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

Answer 11

Well that is what is already mentioned in my previous post http://support.microsoft.com/kb/2216460/ tooo...Anyways let us know

---

vinu

Answer 12

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..

 

------------------------------

BUTTONS:

 

OK

------------------------------

Answer 13

Hi, was able to get rid of SP error installed it successfully and now the original error also has resolved. Thanks,