It looks a Microsoft internal bug.

Take as reference this note.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=464549&wa=wsignin1.0

You are trying to install a wrong CPU2, the correct one is

Cumulative update package 2 for SQL Server 2008 Service Pack 1

http://support.microsoft.com/kb/970315

RTM

===

Cumulative Update 2 contains hotfixes for the...

I agree with Henrico Bekker, uninstall and reinstall again, just take a full old backup of your system databases and users databases and document special setting done at instance levels...

You need to define your requirements very well, full user rights mean sysadmin role?? or what permissions??

What activities the user needs to done??

Please provide more information about your environment, OS, Version, Service Pack, platform, etc.

If this is a dedicate database server leave 4 GB for the OS System and 28GB to database server, please enable AWE setting and lock pages in memory rights to...

Please, enable the step job loggin to get the complete error output and paste the output here to figure out the problem.

Review your SQL Network configuration, TCP IP ports, it looks like a conflict network, verify that both servers ports are different, after try to connect the servername plus port number.

SERVERNAME,PORTNUMBER...

You can use linked server to copy one table from one server to another server and setting the security in better way and more simple to transfer the info from...

You can create a generic user and add that user into every database needed by OLAP system.

Reviewing the logs attached, it looks like there is another installation done in your machine an Express edition, you should uninstall any version before to install the enterprise version.

You can save the import process into DTSX package and verify the workflow step by step too and detect any problem there.

Did you try to use sp_OACreate procedure to test the functionality? Try to use wscript.shell object.

EXEC @hr = sp_OACreate 'WScript.Shell'

You can use the COLLATE clause to force a collation.

Please read this article for more information.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/12/883.aspx

Reviewing the logs attached, it looks like there is another installation done in your machine an Express edition, you should uninstall any version before to install the enterprise version.