Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel 2007 Connect to SSAS 2008 - An error was encounted in the transport layer Expand / Collapse
Author
Message
Posted Wednesday, November 23, 2011 9:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 9:56 PM
Points: 6, Visits: 120
Dear All,

I having an issue when using Excel 2007 connect to SSAS 2008.

Client

1. Window XP SP3

2. Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

Server

1. SSAS 2008 & Window Server 2008 Enterprise 64 bits

When I try to connect to SSAS 2008 using Excel 2007 by providing the correct username and password, but I getting an error as "An error was encounted in the transport layer". When I click "OK", "multidimensional connection 10.0" wizard display. Follow the wizard by prodiving the same username and password and it connected to the cube successfully.

I even try on the same SSAS Server by using Excel to connect to cube, but getting same error.

Anyone know that:-

1. Why I getting an error as "An error was encounted in the transport layer"?

2. Why I only can connect to cube using "multidimensional connection 10.0"?

Thank in advanced


Post #1211433
Posted Thursday, November 24, 2011 8:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 9:56 PM
Points: 6, Visits: 120
Hi All,

I was wondering anybody know the root cause?

Thanks
Post #1211789
Posted Friday, November 25, 2011 7:56 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Today @ 8:56 AM
Points: 1,815, Visits: 3,455
You need to provide more detail/s on exactly what you're doing and then what is happening - ie you're connecting from Excel to AS2K8 how? Using the From OTher Sources option on the data tab? Using the Insert Pivot Table on the Insert tab?

Can't explain the 2nd part of what you're seeing, as I don't know what it is that you're doing. The first part, is likely caused by authentication failure. you can confirm this by running the profiler on the AS instance, you'll likely see a connection attempt from an Anonymous user.

It also sounds like you're entering/typing User/Pwd in the dialog/wizard - generally, you don't do this when in an intranet situation, your credentials are/will be passed across. This was mainly used when connecting to the dll exposed through IIS when in an Internet scenario.

HTH,




Steve.
Post #1212082
Posted Tuesday, November 29, 2011 4:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 9:56 PM
Points: 6, Visits: 120
Hi,

Sorry for late reply.

Below are the details, how I connect to SSAS using Excel:-

1. MS Excel 2007
2. Data Tab --> From Other Sources --> From Analysis Services --> Data Connection Wizard appread
3. Enter the "Server Name". Log on credentials --> Check "Use the following User Name and Password" (Enter the Administrator User Name and Password) --> Next
4. Select Cubes --> Next
5. Click --> Finish
6. Error Message --> An error was encountered in the transport layer.
7. Once I click OK --> "Multidimensional Connection 10.0"wizard appread
8. Enter the User ID and Password --> Next --> Finish
9. Pivot Table show in the Excel

Hope you can provided some adviced.

Thanks
Post #1213058
Posted Monday, July 23, 2012 3:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 10:03 AM
Points: 1, Visits: 72
Hi,

I am experiencing the exact same problem when trying to connect to an SSAS 2008 R2 instance. Did you ever get this fixed and, if so, what was the solution?

Kind regards,
Thijs Nijhuis
Post #1333656
Posted Wednesday, June 5, 2013 2:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 24, 2013 8:21 PM
Points: 5, Visits: 78
Read Devarajan from Microsoft's response from here --> http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/45d6a242-b501-44c9-aec0-1032a38f07eb

"
this seems to be a feature limitation in PowerPivot, We haven't provided custom impersonation capabilities as it's always current NT user while connecting to SSAS. There is a workaround for this, you can run excel using runas to launch excel using that credential.

runas /user:domain\username excel.exe

This will launch excel with the user are trying to impersonate and it will let you do the job you want.

Once you finish creating model and publishing the model, you can schedule refresh job using any nt credentials.

"
Post #1460453
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse